Access Training - Intermediate

Access training building on the skills introduced in our introduction course. During the course the participant will develop a multi-table relational database using "one to one", "one to may" and "many to many" relationships. At the end of the course the participant will have sufficient knowledge to use Microsoft_® Access for complex single user relational databases involving many to many relationships.

Course content:

Relational database principals
Action Queries
Crosstab Queries
Form options for tables related "many to many"
Events
Importing and exporting files
Introduction to macros
Introduction to structured query language (SQL)
Refining the user interface
Database analysis and reporting
Designing filters for reports
Designing reports with subreports
Printing labels
Mail-merging

Course duration 1 day.

Course prerequisites. The course assumes that the participant will have already completed the introduction course in Microsoft_® Access or have thorough awareness of its contents.