Microsoft Access 2003 Intermediate

Target Audience

This course is designed for Delegates needing to create a database

Prerequisites

Delegates must have a working knowledge of a Microsoft Windows operating system and previous use of Microsoft access would be beneficial.

Designing Tables In Access 2003

• Normalising Data

• Establishing Relationships

• Working With Indexes

• Working With Data Types

Designing Queries In Access 2003

• Creating Action Queries

• Creating Parameter Queries

• Creating Calculated Columns In Queries

• Joining Tables

Designing Forms In Access 2003

• Creating Data Entry Forms

• Working With Subforms

• Creating Pop-Up Forms

• Working With Switchboards

Designing Reports In Access 2003

• 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 In Access 2003

• Creating Pivottables And Pivotcharts

• Creating Pivottable Forms

• Creating Pivotchart Forms

Importing And Exporting In Access 2003

• Linking To External Data Sources

• Importing Data Into Access

• Exporting Data From Access

Building Expressions In Acces 2003

• Using The Expression Builder

• Using Common Built-In Functions