Microsoft Access Data Analysis: Unleashing the Analytical Power...

Features

• Cover Type: Paperback with 552 pages
• Published by: Wiley January 4, 2006
• Written in: English
• ISBN 10 Number: 076459978X
• ISBN 13 Number: 978-0764599781
• Book Dimensions: 9.1 x 7.4 x 1.3 inches
• Weighs: 1.6 pounds

Product Description

• Go beyond Excel(r) with Access's more powerful analysis capabilities
• Get better visibility into your data with custom views
• Scale up your data pool without limitation
• Master the four basics of data analysis
• Discover shortcuts with the helpful Input Mask Wizard
• Integrate your data with the web and enterprise data sources
• Avoid the common pitfalls of data crunching
• Harness VBA to improve data analysis
• Leverage information from the field with real-world scenarios

Companion web site
See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.

Back Cover Copy

• Go beyond Excel® with Access's more powerful analysis capabilities
• Get better visibility into your data with custom views
• Scale up your data pool without limitation
• Master the four basics of data analysis
• Discover shortcuts with the helpful Input Mask Wizard
• Integrate your data with the web and enterprise data sources
• Avoid the common pitfalls of data crunching
• Harness VBA to improve data analysis
• Leverage information from the field with real-world scenarios

Companion web site

See examples from this book firsthand, in our companion web site at www.wiley.com/go/accessdataanalysis. The site also includes templates and tools to get you started.

Reader Reviews
Many times have I been tasked to automate analysis with an application and I have always recommended Excel for doing anything with numbers and analyzing them. Doing anything like this with Access is usually a mystery and it takes a long time to put together until now. I was very skeptical since I have many Access books that do not go into detail about how to use Access in an analytical setting. The other books that I have just concentrate on programming, application developing or just simple that just teach you the basics of Access. This book puts it all together for you and even does a little VBA sampling so you can learn to use the analysis with an application you might already have. I was extremely suprised at the way this book was composed with smart but simple step by step examples. The first few chapters saved me a ton of time after I learned many built-in functions for cleaning up data. The collection of functions in the appendix are a gold mine since these help you create expressions and also teach you by defining their meaning and use. After reading this book about a month ago I have been using Excel less and less to do my number crunching and reporting. I was a slave to the updating of cells, links,formulas and cleaning data that was given to me every week, month, and quarters. Now I just imported all my data to Access where I can analyze more data ,better and alot quicker than that other program.... I forget what that was, Oh yeah Excel. You HAVE to get this book in your Access library if you do any work with data analysis and number crunching for financials or statistics. For all of you in any IT field like me that get told to "whip up" a program to crunch some statistics or financials.... this book will be the one to save your butt, it did it for me.