Access Intermediate

This two-day course is appropriate if you have a sound knowledge of Access. You should be familiar with setting up a multi-table database, creating relationships between tables and developing queries, forms and reports. This course will give you the skills and knowledge required to create and distribute more sophisticated Access applications that are intended for others to use.

Audience Profile

It is assumed you have attended our introductory Access course (or similar) or have the equivalent knowledge.

At Course Completion

At the completion of the course you should have gained a better understanding of the techniques required for developing more sophisticated databases incorporating menu switchboards, smarter forms and reports, custom menus and Access security.

Course Topics

review of database design and creation techniques
review of table, query, form and report design
database documentation
using the Expression Builder
creating switchboard forms
enhancing Access forms
an introduction to programming in Access VBA
creating a custom menu
enhancing Access reports
using Access security