Data Analysis with Microsoft Access 2010

Description

Rather than emphasizing the mechanics, forms or report modules within Microsoft Access, DATA ANALYSIS WITH MICROSOFT ACCESS 2010: FROM SIMPLE QUERIES TO BUSINESS INTELLIGENCE focuses on data retrieval and how you can transform data into structures useful for a true understanding of the data. The author broadens the concept of data analysis to encompass Business Intelligence (BI) concepts. To help you most effectively utilize Access, the book focuses on the GUI (graphical user interface) that Microsoft Access uses to create queries. You examine underlying SQL concepts as they relate to Access queries. The book also emphasizes tables, while coverage of forms, reports and macros is addressed only briefly in an optional appendix. You also become familiar with various approaches to data analysis as you learn how Access relates to other tools, such as Microsoft Excel.

CONTENTS:

Introduction.

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.