Access 2003 Level 3

2 Day Course
Hands On
Code DAC03L3

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

Modules

Hide all

Structuring Existing Data (4 topics)

  • Import Data
  • Analyse Tables
  • Create a Junction Table
  • Improve Table Structure

Simplifying Tasks with Macros (3 topics)

  • Create a Macro
  • Attach a Macro to a Command Button
  • Restrict Records Using a Where Condition

Adding Interaction and Automation with Macros (3 topics)

  • Require Data Entry with a Macro
  • Display a Message Box with a Macro
  • Automate Data Entry

Making Forms More Effective (3 topics)

  • Change the Display of Data Conditionally
  • Display a Calendar on a Form
  • Organize Information with Tab Pages

Writing Advanced Queries (5 topics)

  • Create Unmatched and Duplicates Queries
  • Group and Summarize Records Using the Criteria Field
  • Summarize Data with a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Display a Graphical Summary on a Form

Making Reports More Effective (4 topics)

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

Maintaining an Access Database (7 topics)

  • Link Tables to External Data Sources
  • Back Up a Database
  • Compact and Repair a Database
  • Protect a Database with a Password
  • Determine Object Dependency
  • Document a Database
  • Analyse the Performance of a Database

Prerequisites

To ensure the successful completion of Microsoft ® Office Access 2003: Level 3, we recommend completion of the following Element K courses, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source: Microsoft ® Office Access 2003: Level 1; Microsoft ® Office Access 2003: Level 2

Sections