Microsoft Access 2007 Data Analysis

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.

Table of 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

Part V: Appendixes
Appendix A: Data Analyst’s Function Reference
Appendix B: Access VBA Fundamentals
Appendix C: Error Message Reference