Data Analysis with Access


Data Analysis with Microsoft Access 2010

Published by Cengage Learning in November 2011, paperback and eBook, 386 pages, $29.99.
This book is currently out of print. Used copies may be obtained from sites shown below.

Click here to purchase the book on Amazon in the US

Click here to purchase the book on other US and non-US sites

Click here to view supplemental materials for the book

DATA ANALYSIS WITH MICROSOFT ACCESS 2010 is an introduction to Access with an emphasis on topics relevant to data analysis. The goal is to help the analyst gain a true understanding of data and the information it contains. Access queries are covered in detail, both in terms of the mechanics of their design, and how they can be used for typical data analysis tasks. The book is written in an easy-to-understand tutorial style, with new topics introduced in a logical and intuitive sequence. Numerous screenshots are included, so you won’t need to sit with a computer as you read the book. The author also broadens the concept of data analysis to encompass business intelligence (BI) topics, including valuable material on how to use Access and Excel pivot tables. Additional features include “See the SQL” sidebars that allow interested readers to learn SQL as they are learning Access, and “Focus on Analysis” sidebars that provide details on a number of useful quantitative topics. A companion website has a sample database that correlates with the BI material in the book. In short, this is the only book you’ll need to gain a working knowledge of Access, and how it can be used for data analysis.

Table of Contents:

Part I – Getting Started
1. What is Data Analysis?
2. Overview of Access

Part II – Access Queries
3. Tables and External Data
4. Select Queries
5. Joins and Relationships
6. Relational Database Design
7. Expressions and Functions
8. Selection Criteria
9. Summarizing Data
10. Subqueries and Set Logic
11. Action Queries
12. Crosstab Queries and Pivot Tables

Part III – Creating Business Intelligence
13. What is Business Intelligence?
14. Dimensional Modeling
15. The Data Warehouse
16. Excel Pivot Tables

Appendix A: Forms, Macros, and Reports
Appendix B: A Sample Business Intelligence Database

Purchasing the book

Used copies of “Data Analysis with Microsoft Access 2010” can be purchased from these online bookstores in the US:


Used copies of the book can also be purchased from these sites outside of the US:

Amazon Canada
Amazon China
Amazon France
Amazon Germany
Amazon India
Amazon Italy
Amazon Japan
Amazon Spain
Amazon UK
Book Depository (UK)

Comments Off on Data Analysis with Access
%d bloggers like this: