Intermediate Access

Duration: ONE DAY

Pre-requisites:

Delegates should have attended the Introduction course 

Course Objectives:

After attending the course delegates should have enhanced their use and understanding of the intermediate features 

Course Content:

Further queries: 

Using Totals queries for summarising data

Using Crosstab queries for cross-tabulating and summarising data

Using Action queries

Make Table queries

Update queries

Append queries

Delete queries 

Macros:

Creating and running a macro

Assigning macros to a keyboard shortcut or a form control 

Making Decisions in Macros

Data Validation via Macros

Further forms design:

Main/sub forms

Linking main forms to sub forms

More advanced controls

List boxes and combo boxes to lookup data in other tables/queries

Option groups

Calendar controls

Tab controls

Further report design: 

Main/sub reports

Linking main reports to sub reports

Working with calculated controls and summary groups

Referring to control values in a report

Using conditional statements in a report