Microsoft Access Introduction

Getting Started and Table Design
Create a new database
Overview of the Microsoft Access Environment
Create new tables
Set field names
Choose data types
Consider and set field properties
Create a drop down list

Understanding Relationships
Create One to Many Relationships
Create One to One Relationships
Change Relationship Properties
Understand Referential Integrity

Work with Forms
Create a standard Form
Create a Form using the Wizard
Re-design a Form
Create a Form with a sub-form
Input data using Forms
Work with Queries
Create and save standard Queries
Sort data within a Query
Set criteria for Queries
Concatenate data within a Query
Create calculations in a Query
Use Parameter Query

Work with Reports
Create a report from Table data
Create a report from Query data
Group Information in a Report
Re-design Report elements
Create Mailing Labels

Export data from Microsoft Access
Export information to Microsoft Excel
Export information to Microsoft Word
Export information to a PDF file
Use the Mail Merge feature

Any person who wants to learn how to build a database. Our courses are generally aimed at business users.

A desire to learn how to build databases

Certificate of attendance

Engaging trainers delivering Live Online
Up to 4 delegates only on a public course
We post your course materials to you and send a link to join the course
1 year's after course support included

Enroll on our course via our website.
We will then send your course information on enrollment