00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Microsoft Access Advanced



To acquire more advanced knowledge of Access, including relational database design, macros, VBA, database security and integration with other MS Office applications.

Price €300 per person


  • Book a place on this course and pay with your credit card.14 September 2017 , 1 Day
  • Book a place on this course and pay with your credit card.22 November 2017 , 1 Day


Aimed at users who have a good working knowledge of Microsoft Access and who would like to reach an advanced level.




Course Outline
Click here to download course oultline

Introduction and Overview
Programme Overview
Explore the Ribbon

Advanced Database Design
Developing Applications
Naming Conventions
Input Masks
Validating and Restricting Data

Relational Databases
Relational Databases
Database Capabilities
Relational Database Characteristics
Different Types of Relationship
Creating a One-to-Many Relationship
Primary Keys
Referential Integrity

Create Macros
Adding Actions and Arguments
Creating Macro Groups
Attach Macro to Command Button
Customising Toolbars with Macros

Toolbars / Switchboard
Creating Toolbars
Customising Toolbars using Macros
Creating a Switchboard
Modifying a Switchboard
Startup Options

The VB Window
Module Types
Variables and Variable Scope
Object Properties, Methods and Events
Functions and Procedures
Conditional Logic and Looping Constructs

Importing, Linking and Exporting
Importing Data
Linking Data
Importing from another Access Database
Importing from a Spreadsheet
Exporting Data
Automate Importing, Exporting or Linking
Startup Options
Export linked data source information to Excel

Database Management Tools
Compact and Repair Database
Compact on Close
Table Analyzer

Using the ‘Tell me what to do…’ function

Course Summary and Review
Recap of Topics Covered
Question Time

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.