MS Access 2007 Data Analysis

Part I: Fundamentals of Data Analysis in Access
Part I, which includes Chapters 1, 2, and 3, provides a condensed introduction to Access. Here, you will learn some of the basic fundamentals of Access, along with the essential query skills required throughout the rest of the book. Topics covered in this Part are: relational database concepts, query basics, using aggregate queries, action queries, and Crosstab queries.
Part II: Basic Analysis Techniques
Part II will introduce you to some of the basic analytical

tools and techniques available to you in Access.
Chapter 4 covers data transformation, providing examples of how to clean and shape raw data to fit your needs.
Chapter 5 provides in-depth instruction on how to create and utilize custom calculations in your analysis. Chapter 5 also shows you how to work with dates, using them in simple date calculations, or performing advanced time analysis.
Chapter 6 introduces you to some conditional analysis techniques that allow you to add logic to your analytical processes.
Chapter 7 covers the fundamentals SQL statements.
Chapter 8 picks up from there and introduces you to subqueries and domain aggregate functions.
Chapter 9 demonstrates many of the advanced statistical analysis you can perform using subqueries and domain aggregate functions.
Chapter 10 provides you with an in-depth look at using PivotTables and PivotCharts in Access.
Chapter 11 gives you an in-depth view of how macros can help increase you productivity by running batch analysis.
Chapter 12 demonstrates how a little coding with Visual Basic for Applications (VBA) can help enhance data analysis.
Chapter 13 offers some final thoughts and tips on query performance, database corruption, and how to get help in Access.