select courses

we have a wide range of courses proven to be effective

We have a wide range of diverse courses proven to be effective

create your own

Partnering with you to develop your solutions

public sector

We have a wide range of courses to suit you. Explore our full range here


Free Download

Please complete this form to instantly receive your FREE PDF by email

Microsoft Access - Advanced

1 Day


Designed for experienced users who wish to extend their knowledge further and for those who are responsible for maintaining databases for other users


Participants should have attended the introductory course or have been using the software for at least three months and have an understanding of tables, queries and reports before attending this course to fully benefit.


Time efficient manipulation and creation of data to support business decisions.

Programme Objectives

Participants will be able to design a relational database, write complex queries and create advanced forms and reports.  In addition they will be able to develop more sophisticated database models for use in a multi-user environment.

Programme Content

  • A Review of the Basics
  • Indexes
  • Hyperlinks
  • Macros – Creating, Events, Grouping, Conditional
  • Setting up Menu Systems
  • Creating Custom Menus
  • Creating Option Buttons, Combo and List Boxes
  • Startup
  • Switchboard Manager
  • The Need for Security
  • Activating Log On Procedure
  • Setting up User/Group Accounts
  • Determining who has access to the data and assigning permissions


Exact content will vary depending on version