Course Introduction


Please watch this video to preview one of the Microsoft Access databases that you will make during this course.

Introduction to Microsoft Access

Course Description

This introduction to Microsoft Access provides the perfect foundation for developing expertise. Even though it is a beginner’s course, delegates will build two fully functioning relational databases.

This course has been designed to be as hands-on as possible. It is project-based and takes you through the steps involved in building an Access relational database from the ground up.


Topics Covered in the Course

Relational Database Theory – what is a relational database and how does it compare to the way data is stored in Excel, for example?

Tables – designing tables to store data. Setting data types and field properties.

Importing Data – importing data into your Access database stored in Excel or as text files.

Creating Relationships Between Tables – understanding primary and foreign keys and creating relationships between tables.

Design Forms – that look great and function well.

Create Select Queries – understand how to set AND/OR criteria, use comparison operators and wildcards.

Design Reports – that look professional.

Create a Front-End for your Database – create a navigation form with command buttons that open your forms and reports. Set database options that control what appears/doesn’t appear to your users when they open the database.

The course was created using Access 365 (2019) but will work for earlier versions.

Course Curriculum


  Introduction
Available in days
days after you enroll
  Getting to Grips With Tables in Microsoft Access
Available in days
days after you enroll
  Getting to Grips With Forms in Microsoft Access
Available in days
days after you enroll
  Getting to Grips with Queries in Microsoft Access
Available in days
days after you enroll
  Getting to Grips With Reports in Microsoft Access
Available in days
days after you enroll
  Get to Grips With Navigation Forms
Available in days
days after you enroll
  Student Project
Available in days
days after you enroll

Pricing - 12 Months Access to the Course