This two-day course is designed for delegates who have attended the Access Introduction & Intermediate Course or have a comprehensive knowledge of Databases.
MS Access (Introduction to Intermediate)
English
Course is facilitated by a competent & experienced subject matter trainer, who utilises the following techniques to ensure that the session is practical and experiential:Â Questions; Discussion; Exercises & Assessments.
Any person who needs to expand their knowledge of Relational Databases, create advanced queries, split & share date across applications and create customised forms, reports and macros.
2 Days
Module 1 | Overview of Database Relationships Understanding Outer & Inner Relationships Understanding Data Integrity |
Module 2 | Creating AutoLookup Queries Using Calculated Fields Creating Make Table Queries Creating Append Queries Creating Update Queries Create Complex Parameter Queries |
Module 3 | Creating Advanced Forms Adding Sections Adding Headers & Footers Adding Custom Controls Using Text Boxes, Option Buttons, Check Boxes, List Boxes, Command Buttons Adding calculated Fields |
Module 4 | Creating Advanced Reports Adding Header & Footer Information Creating Groups and Subtotals Adding additional Subtotals Formatting & Editing Subtotals & Grand Totals |
Module 5 | Creating Custom Dialog Boxes Customizing the Navigation Bar Customizing the Ribbon |
Module 6 | Creating a Customized Switchboard Using the Switchboard Wizard to Create a Switchboard Adding Buttons to Switchboards Creating Multiple Switchboard with Links Setting the Switchboard to appear at Startup Customizing the Switchboard Creating an ACCDE Frontend |
Module 7 | Creating Macros Understanding Macro Actions Determining when the Macro should play Editing Macros Dealing with Macro Errors Creating a Startup Macro |
Module 8 | Sharing Data with Multiple Users Splitting the database to create a Backend & a Frontend. Changing the Database Start-up Options Database Password Protection |
Module 9 | Compacting & Repairing a Database Compacting a Database Repairing a Damaged Database Documenting your Database |