Advanced

Microsoft Access 2003/2007/2010

Advanced Level

The course is designed for delegates who have attended the intermediate course, or who have a good solid working knowledge of Access, and relational database management. By the end of the training session, delegates will have an extensive working knowledge of Access, where they will be able to produce efficient, well designed, automated applications.

Pre-Requisite: Delegates attending this course should be already working with an Access database and wish to increase their knowledge level, or should be converting from another computerised database management system.

This course does not cover programming in Microsoft Access

Duration: 1 Day

Introduction to Databases

Database Elements

Building a Relational Database

Designing a good database
Normalisation
Primary Keys
Indexes
Data Integrity
Field properties
Validation Rules
Table relationships
Input Masks
Lookup Fields
Referential Integrity

Creating Relational Queries

Working with related tables in a query
Setting join types
Find unmatched query
Find duplicates query

Calculating in Queries

Summary Queries
Crosstab Queries

Advanced Form Features

Using advanced forms features
Multi-table forms
The Toolbox
Bound and unbound controls
Creating a calculated control

Producing Reports

Creating Reports
Applying sorting and grouping to reports
Performing calculations in reports
Creating custom report pages
Using the Chart Wizard
Using the Label Wizard

Importing, Exporting and Attaching Data

Importing Data
Attaching Data
Exporting Data

Action Queries

Action Queries
Make Table Queries
Append Queries
Delete Queries
Update Queries

Customising Menus and Toolbars

Creating custom menus and toolbars

Macros and Command Buttons

Macros and Command Buttons defined
Creating a macro
Assigning the macro to a command button
Creating a Menu Form
Setting Start-up options

Other Advanced Access Features

Hyperlinks
Database Management Tools
Multi-User Database