One Day Course
Existing users of Access wanting to use some of its more advanced features.

This course outline shows topics covered during a typical one-day training course. However, ICS offer a flexible approach - if preferred, courses can be tailored to suit delegates’ needs: select those areas where specific training is required.
 

 

Contents:

Advanced queries

 

Filtering query results
Parameter queries
Creating summary queries
Query join types

Action queries

 

Planning an action query
Make table queries
Delete queries
Append queries
Update queries

Building and modifying forms

 

Using advanced forms features
Creating calculated controls
Adding graphics to a form
Multi-table forms
Using the sub form control

Queries

 

Multi-table queries
Calculated fields
The Expression Builder
Calculating summary information
Cross tab queries

 

Register your interest

 

 Back to course list

 

 

Producing Reports

 

Sorting and grouping in reports
Performing calculations on reports
Adding graphics to a report
Using the sub report control

Macros

 

Creating macros
Modifying actions and arguments
Creating a macro group
Customising toolbars with a macro

Pivot tables (not Access 2000)

 

Creating Pivot tables
Modifying Pivot tables
Creating Pivot charts

Switchboards

 

Create a switchboard
Changing the start up options