
Reserve it at BN.com & pick it up in 60 minutes at your local store.
Enter a zip code
(Paperback)
Chart a course for more effective data analysis with Access 2007. With this resource, you’ll learn how Access 2007 offers powerful functionality that may be better suited to your data analysis needs. Learn to analyze large amounts of data in meaningful ways, quickly and easily slice it into various views, automate redundant analysis, and save time—all using Access. If you know a bit about table structures and formulas as well as data analysis, start thinking outside the chart.
More Reviews and RecommendationsMichael Alexander is a Microsoft Certified Application Developer (MCAD) with more than thirteen years of experience consulting and developing office solutions. He currently serves as the director of an analytical services department for a $700 million company. He also runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.
Reader Rating:
See Detailed Ratings
April 21, 2007: While most Access books focus on designing forms and reports, this book goes straight to the basics of analyzing data. After a short review of table design, the author quickly gets to the heart of data analysis by showing how to construct queries by using Access?s graphical interface and illustrating how to write your own SQL. Advanced query techniques using subqueries and domain aggregate functions are fully described. The author demonstrates how to create pivot tables and charts from within Access and how to use Visual Basic for Applications to increase the power of your application. I recommend this book for beginning and intermediate users of Access who need to learn how to use Access to analyze data. Truitt L. Bradly Senior Actuarial Analyst Microsoft Access MVP 2007