Intermediate Microsoft Access

Designed to take advantage of the more complex features of Microsoft Access, this course is for users who wish to improve their basic skills and knowledge. Our Intermediate Microsoft Access training course will give you the skills to build on a database application.

On this course you will work with and understand relational databases and related tables, you will able to create more advanced reports and forms, generate and action more complex queries and create simple macros.

The course will give you hands on experience via structured exercises during the session and will give you the opportunity to practice the skills you have learned. This course is the ideal stepping stone towards our Microsoft Access Developer course.
To get the most out of this course some experience of using Microsoft Access (including the topics covered on our Introduction Microsoft Access course) is recommended and ideally you should be comfortable with the Microsoft Windows environment.

Course Duration

1 Day

Course Content

Download Course Content PDF

  • Revision
    • Review of Introduction day
    • Revision Exercise
  • More about Datasheets
    • Finding Information in a Datasheet
    • Replacing Information
    • Sorting in a Datasheet
    • Filtering for Ad-hoc enquiries
  • Relationships between Tables
    • The Northwind Sample Database
    • Understanding Links
    • Multi-Table Queries
    • Creating the Relationships
  • Custom Forms
    • Starting from Scratch
    • Control Properties
    • Using List / Combo Boxes
    • Check Boxes / Option Buttons
    • Calculations on a Form
  • Custom Reports
    • Starting from Scratch
    • Sorting and Grouping
    • The Control Types to be Used
  • Action Queries
    • Make Table Queries
    • Append Queries
    • Delete Queries
    • Update Queries
  • Macro Design
    • Creating a Macro
    • The Macro Design Window
    • Saving and Running the Macro

Download Full Course Schedule PDF

Ask a question


Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact