Contents
Part I Fundamentals of Data Analysis in Access
Chapter 1 The Case for Data Analysis in Access
Chapter 2 Access Basics
Chapter 3 Beyond Select Queries
Part II Basic Analysis Techniques

Chapter 4 Transforming Your Data with Access
Chapter 5 Working with Calculations and Dates
Chapter 6 Performing Conditional Analysis
Part III Advanced Analysis Techniques

Chapter 7 Understanding and Using SQL
Chapter 8 Subqueries and Domain Aggregate Functions
Chapter 9 Running Descriptive Statistics in Access
Chapter 10 Analyzing Data with Pivot Tables and Pivot Charts
Part IV Automating Data Analysis

Chapter 11 Scheduling and Running Batch Analysis
Chapter 12 Leveraging VBA to Enhance Data Analysis
Chapter 13 Query Performance, Database Corruption, and Other
Final Thoughts