Access 2007 Level 3

1 Day Course
Hands On
Code DAC07L3

This course has been retired. Please view currently available User Microsoft Office Training Courses.


Collapse all

Structuring Existing Data (3 topics)

  • Analyze Tables
  • Create a Junction Table
  • Improve the Table Structure

Writing Advanced Queries (5 topics)

  • Create Subqueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart

Simplifying Tasks with Macros (5 topics)

  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro

Making Effective Use of Forms (3 topics)

  • Display a Calendar on a Form
  • Organize Information with Tab Pages
  • Display a Summary of Data in a Form

Making Reports More Effective (4 topics)

  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Create a Report Snapshot

Maintaining an Access Database (5 topics)

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database


To ensure the successful completion of Microsoft® Office Access 2007: Level 3, the following Element K courses or equivalent knowledge are recommended for familiarity with: basic and intermediate features of Access tables, relationships, queries, forms, and reports, as well as: Microsoft® Office Access 2007: Level 1 Microsoft® Office Access 2007: Level 2

Course PDF