MS Access 2007 - Data Analysis and Reporting

Introduction to Relational Database

Crosstab Queries

·       Relational vs. Flat File Database

·       What are Crosstab Queries

·       Creating Relationships

·       Creating Crosstab Queries

·       Enforced Referential Integrity

·       Rows, Columns and Values

·       Join Types

·       Join Properties

Office Links

·       Collect and Paste among Programs

Select Queries

·       Collect multiple items with Clipboard

·       Select Query v Select Filters

·       Analyse with Excel

·       Creating a Select Query

·       Publish and Merge with Word

·       Multi-Table Queries

·       Entering Search Criteria

Enhanced Report Design

·       Query Expressions

·       Understanding Report Bands

·       Sort and Sort Within

·       Adding Titles, Labels and Fields

·       Hiding a Column

·       Calculated Fields in a Report

·       Calculated Fields

·       Sorting and Grouping

·       Summary Total Queries

·       Find Unmatched Records Wizard

Pivot Tables

·       Using the Pivot Table Wizard

Parameter Queries

·       Page, Row, Column and Value Fields

·       Creating Parameter Queries

·       Filtering Data

·       Pattern Matching

·       Grouping Dates

Action Queries

Graphs

·       Make Table Queries

·       Selecting the Graph Data

·       Delete Queries

·       Free-Standing v Embedded Graphs

·       Append and Update Queries

·       Changing the Properties of a Graph