Microsoft Access 2007 Data Analysis

has a quick and well written introduction to creating queries in Access. Also covers some more advanced data analysis tools. Well worth the investment.

This is an excellent text, it was used in my CIS 2640 Business Reports and Analysis class at Western Michigan University in the Spring of 2008. I learned a great deal about building tables and queries in Access, a tool that will come in handy in almost any business related work. It's user friendly, and I feel is a good price for what it offers, and is designed from a beginner to someone who is experienced in Office 2003, looking to update their skills.

I purchased this book as a textbook for an Access class I am taking. It is a very good source to help with the class. I especially like to be able to go to the site listed on the book and work with the data on line. This helps me to practice the different tasks the book is teaching. I recomend this to anyone who is learning Access.

It's refreshing to see a book about data-crunching with Access (instead of how to create a "contact database" or something like that). Clearly written with concrete examples.

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 Office - Access - Most Valuable Professional 2007