Microsoft Access 97 Intermediate

Access training London

Training is available in one of our 6 London centres, on-site or tailored training courses

Other Microsoft Access training courses

Microsoft Access 97 Intermediate

Duration: 1 Day
Level: Intermediate
Prerequisites: A working knowledge of Access or our Access Introduction course
Platform: PC
Leads to: Access 97 Advanced course

Syllabus includes:

Creating relational databases
Database normalising
Introducing relating tables
Adding referential integrity

Working with related tables
The lookup wizard
Changing lookup fields
Inputting data to related tables

Defining data entry rules
Using input masks
Setting a property
Setting a validation rule

Using advanced query features
How to join a table in queries

Creating a calculated field
Using an action query Creating advanced queries
Summarise and group values
Create a crosstab query
Using a parameter query
Using an index

Creating advanced form design
Working with graphics
Working with calculations
Working with combo boxes
Working with unbound controls

Using advanced report features
Create customized headers and footers
Add a calculated value
Work with sub-report