MS Access Advanced – Virtual Class

This live, facilitator led MS Access Advanced training course is delivered to you online at your computer. You still have all the benefits of interacting with our facilitators in real time, just at your office or home desk. You can ask questions both during the training and afterwards with our free post course help desk.

Course Times

• 9am to 4pm

Course Content

Database Theory

• Designing a multi-table relational database
• Normalising the database
• Understanding table relationships and Referential Integrity
• Indexing

Advanced Queries

• Understanding query joins
• Creating Multi-table queries using different join types
• Creating action queries which update and delete data

Advanced Form Features

• Creating sub-forms
• Using bound combo boxes
• Creating calculated controls
• Setting defaults values and other form properties

Working with Macros

• Creating and saving macros
• Automating Access processes with macros
• Using macros on forms
• Add actions to macros
• Set arguments for macros
• Using Msgbox and Inputbox functions to interact with the user

Database Deployment

• The database splitter wizard
• Working with a split database
• Create switchboards as a user interface tool
• Create custom menus & toolbars and setting start up options for a database

On completion of the course, participants will be able to create customised, menu-driven applications using the advanced features of Microsoft Access.

Completion of the Access Intermediate course or equivalent knowledge is required.

“I am extremely likely to recommend ATI-Mirage and this course” Louise from Doray Minerals Ltd.