Insight IT Training - a flexible computer training service for business users

Microsoft Access Intermediate Outline

Aims of the One-Day Course

This course has been designed for existing users who require further skills in the use of Access. The course provides training in Relational Databases and introduces methods of automating a database with the use of Form Controls and simple macros. The course is 100% hands-on, with exercises to practice the skills as you learn them.

Course Content

Relational Databases
- Linking tables in queries and forms
- Referential integrity
- Cascading updates and deletes
Queries
- Calculated fields
- Expressions
- Action queries
Designing Forms
- Creating controls
- Text boxes; list boxes; combo boxes
- Option buttons; check boxes; toggles
- Forms and sub forms

Designing Reports
- Adding & adjusting controls
- Sorting & grouping
- Page breaks
- Totals and sub totals
Connectivity
- Importing and exporting tables
Introduction to Macros

Prerequisites

Trainees must have attended the Introduction to Microsoft Access course or have some experience of creating Microsoft Access databases.

Course Duration

Six hours (9.30am to 12.30pm and 1.30pm to 4.30pm).

Next Course

Microsoft Access Advanced

Prices