Select Page
Microsoft Access Course

This Microsoft Access Course is suitable for all Access users or anyone new to the application. You'll learn the foundations of using and understanding an Access database, and be confident in moving around its environment.


Suitable for All Levels

2 Day Course

Certification Awarded


Course overview

  • This course starts you at the beginning of Access. It will guide new Access users through the powerful Microsoft Access program. You will gain a fast, practical and extensive knowledge of the powerful features of this package, explaining the structure, design and capabilities of databases.

Skills you’ll learn

  • Create and manage database objects

  • Master creating tables and modifying their properties

  • Setup, run and edit queries

  • Design forms and reports

  • Export tables, queries to Microsoft Excel

  • Understand what table relationships are

Who would benefit

  • New or existing users of databases who would like to gain a better understanding of how a database is constructed and managed.

Why take this course

  • To be able to design and build a database incorporating the use of forms, queries and reports. You will gain a better understanding of this application and how the various objects relate and depend on each other.


  • At the end of the course, you’ll be Certified by the Irish Academy of Computer Training.
  • CPD Certification

CPD Certification


  • No prior knowledge is required, some knowledge of excel maybe useful
  • Software is provided in the Classroom and Live Virtual options

Learning paths

Why choose IACT

  • Ireland’s leading training provider for 30 years
  • Full-time Certified Trainers who use the software every day
  • Smaller class sizes to accelerate learning

Course curriculum

Section 1: Tables
In this first section, you’ll learn how to create a table;

  • Opening the Access Application;
  • Create a blank access database
  • Create a table using design view
  • Create field names and assign data types
  • Use the primary key
  • Modify table properties
  • Add, delete, edit records in datasheet view
  • Sort and filter records in datasheet view
Section 2: Queries
The second section covers everything you need to know about creating and running queries;

  • Create a query in design view based on a table
  • Add and remove fields from an existing query
  • Setup criteria:
    • Use OR and AND queries
    • Use wildcards and operators in a query
    • Sort a query
Section 3: Forms
This section covers creating forms; so that it is user-friendly;

  • Create a form based on a table using the wizard
  • Change the layout of the form in design view
  • Add company logos to the form
  • Add text to the form
  • Add, delete and edit records in form view
  • Delete a form
Section 4: Reports
This section covers creating reports for printing purposes;

  • Create report based on a table using the wizard
  • Change the layout of the report in design view
  • Modify the title of the report
  • Insert a date into the report
  • Preview the report
  • Delete a report
Section 5: Relationships and Excel
This section covers what a one-to-many relationship is, and how to export content to excel for further analysis.

  • Understand a one-to-many relationship between two tables
  • Create a two table query to view all records from both tables
  • Export a table or query to Excel

Contact us.

We'll reply quickly.


  • This field is for validation purposes and should be left unchanged.

I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.

  • No products in the cart.