Intermediate Access

The purpose of this course is to expand upon your ability to use Access in your day to day microcomputer work. The course covers those features which enable the participant to create conveniences for user's own convenience, or that of other users

This course is divided into five main sections including the creation of screen forms, multiple relations between tables, and advanced queries. The features used include the Form design mode, Edit Relationships, SQL, the Report and Graph design mode.

This course is intended for those who have taken the Introductory course, or who have experience working with Access on a day to day basis. The class exercises provide "hands-on" experience in using the Access commands. More than 70% of class time is hands-on use of Access.

Objectives

By the end of the program participants should:

• Create a customized data entry and editing screen form
• Be familiar with the Edit Relations mode and its use
• Construct relations: many to one, and one to many including multiple field keys
• Create action queries using the Query mode.
• Create a Form including subforms into multiple tables
• Report on more than one table simultaneously
• Create a Graph from an Access data table