Access 2003 Intermediate

Core Topics

Introduction To Microsoft Access 2003

· What Is Access?

· Creating Files

· Opening And Closing A Database File

The Database Window

· The Database Menu Bar

· The Database Window Toolbar

Tables In Access

· Normalising Data

· Establishing Relationships

· Working With Indexes

· Working With Data Types

Designing Queries In Access

· Creating Action Queries

· Creating Parameter Queries

· Creating Calculated Columns In Queries

· Joining Tables

Designing Forms In Access

· Creating Data Entry Forms

· Working With Subforms

· Creating Pop-Up Forms

· Working With Switchboards

Designing Reports In Access

· Working With Standard Reports

· Working With Pop-Up Reports

· Working With Subreports

· Working With Report Snapshots

· Developing Data Access Pages

Working With Pivottables And Pivotcharts

· Creating Pivottables And Pivotcharts

· Creating Pivottable Forms

· Creating Pivotchart Forms

Importing And Exporting

· Linking To External Data Sources

· Importing Data Into Access

· Exporting Data From Access

Building Expressions

· Using The Expression Builder

· Using Common Built-In Functions

Follow up Course

Access 2003 Advanced