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.
9am to 4pm
Designing a multi-table relational database
Normalising the database
Understanding table relationships and Referential Integrity
Understanding query joins
Creating Multi-table queries using different join types
Creating action queries which update and delete data
Advanced Form Features
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
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.