Merehall Training Getting People on Course

Microsoft Access 2003 Intermediate Level

THE NORTHWIND DATABASE

• Installing The Northwind Database

DESIGNING 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 PIVOT TABLES AND PIVOT CHARTS

• Creating Pivot tables And Pivotcharts
• Creating Pivot table Forms
• Creating Pivot chart 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