Cover -- Contents -- Acknowledgments -- About the Author -- Introduction -- PART I: GETTING STARTED -- Chapter 1 What Is Data Analysis? -- Excel Basics -- Access Basics -- Comparing Access and Excel -- The Purpose of Analysis -- Data Transformation -- Quantitative Analysis -- Visualization -- The Advantage of Access -- Chapter 2 An Overview of Access -- Access and SQL -- Relational Databases -- The Access User Interface -- The Backstage View -- PART II: ACCESS QUERIES -- Chapter 3 Tables and External Data -- Creating Tables -- Data Types -- Indexes and Primary Keys -- NULL Values -- Importing Data -- Linking to Data -- Exporting Data -- Chapter 4 Select Queries -- Query Types and Views -- Creating Queries -- The Design View -- The Datasheet View -- The SQL View -- Selecting All Fields -- Sorting Data -- Chapter 5 Joins and Relationships -- Joining Multiple Tables -- Queries as Virtual Tables -- Table and Column Aliases -- Join Properties -- Finding Unmatched Records -- Self Joins -- Relationship Tools -- Chapter 6 Relational Database Design -- Goals of Normalization -- How to Normalize Data -- The Art of Database Design -- Alternatives to Normalization -- Chapter 7 Expressions and Functions -- Constants and Identifiers -- Arithmetic Operators -- String Operators -- Functions -- Text Functions -- Composite Functions -- Date/Time Functions -- Format Properties -- Math and Financial Functions -- Conversion and Inspection Functions -- Chapter 8 Selection Criteria -- Specifying Criteria -- Comparison Operators -- Limiting Rows -- Pattern Matching -- Boolean Logic -- Advanced Boolean Logic -- BETWEEN and IN -- Testing for NULL Values -- Conditional Logic -- Parameters -- Chapter 9 Summarizing Data -- Distinct Values -- Aggregate Functions -- Grouping Data -- Selection Criteria on Aggregates -- Chapter 10 Subqueries and Set Logic.

Using Queries as a Data Source -- Finding Duplicate Records -- Using Subqueries as Criteria -- Using Subqueries as Fields -- Union Queries -- Chapter 11 Action Queries -- Make Table Queries -- Append Queries -- Delete Queries -- Update Queries -- Chapter 12 Crosstab Queries and Pivot Tables -- Crosstab Queries -- The PivotTable View -- Exporting to Excel Pivot Tables -- The PivotChart View -- PART III: CREATING BUSINESS INTELLIGENCE -- Chapter 13 What Is Business Intelligence? -- Data Warehouses -- Survey of Microsoft BI Software -- Business Intelligence Revisited -- Access and Business Intelligence -- Chapter 14 Dimensional Modeling -- Star and Snowflake Schemas -- Fact Tables -- Dimensions and Hierarchies -- Slowly Changing Dimensions -- Chapter 15 The Data Warehouse -- Designing the Star Schema -- Creating Dimension Tables -- Creating Fact Tables -- Creating the Data Warehouse -- Querying the Data Warehouse -- Migrating to SQL Server -- Simplified Dimensional Models -- Chapter 16 Excel Pivot Tables -- Connecting to Access -- The PivotTable Field List -- Layout Options -- Filtering Data -- Grouping and Formulas -- Drill Down and Drillthrough -- Using PowerPivot -- Appendix A: Forms, Macros, and Reports -- Appendix B: A Sample Business Intelligence Database -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- Y -- Z.