Microsoft Access: Advanced

Microsoft Access: Advanced

Overview and Objectives

This two-day course is designed to help a delegate to obtain the skills required to work with Charts & Pivot Tables, Create Macros and Customize Microsoft Access.

A delegate will also learn to work with Advanced Queries, Forms and Reports.

Course Outline

This course consists of 11 modules
Module 1Creating Charts & Pivot Tables
Creating a Freestanding Chart
Customizing a Chart
Building a better Chart
Freezing the Data in Your Chart
Understanding Pivot Table Procedures
Creating a Pivot Table — Wizard
Editing a Pivot Table
Module 2Networking & Security
Allowing Users to Share Data
Preventing Exclusive Access
Editing Data on a Network
Multi-User Settings
Securing your Database
The User-Level Security Wizard
Password Security
Module 3Macros
How to Create a Macro
Determining when a Macro Plays
Summary of Macro Actions
Creating Macro Groups
Editing a Macro
Dealing with Macro Errors
Creating a Macro to Run at Startup
Module 4Creating Custom Switchboards
Changing a Wizard-Created Switchboard
Creating a Switchboard from Scratch
Filling out the Switchboard
Making a Switchboard appear at Startup
Module 5Customize Access
Creating Custom Dialog Boxes
Creating Custom Toolbars
Creating Custom Menus
Module 6Creating Complex Filters
Choosing Fields to Filter
Specifying Selection Criteria
Saving a Filter as a Query
Module 7Advanced Queries
Creating AutoLookup Queries
Using Calculated Fields
Creating Crosstab Queries
Creating Action Queries
- Update Query
- Append Query
- Make Table Query
Module 8Advanced Forms & Reports
Creating a Form/Report from scratch
Designer Skills
Adding Your Own Controls
- Text Boxes
- Option Buttons
- Check Boxes
- List Boxes
- Command Buttons
- Hyperlinks
Calculated Fields
Putting a Preprinted Form on Screen
Module 9Personalizing Access
Personalizing Work Environment (Changing Option Settings)
Personalize a Database (Changing Startup Options)
Module 10Speeding up your Database
Speeding up General Performance
Speeding up Tables
Speeding up Queries
Speeding up Forms & Reports
Module 11Administering Your Database
Backing Up a Database
Compacting a Database
Repairing a Damaged Database
Documenting Your Database
Replicating Your Database

Microsoft Access: Advanced

Who should attend?

Any delegate wanting to obtain skills to design relational database structures using Microsoft Access and master the design and customization tools available for queries, forms and reports.


2 Days


R2 540.00 (excl. VAT)


  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire
Download Course Information

Microsoft Access: Advanced

Course Schedule

View the available course dates