Microsoft Access Introduction Course

A comprehensive 2-day Microsoft Access training course suitable for complete beginners to Microsoft Access. After the training you will able to create a database from scratch. You will understand and be able to build tables, fields and records, set the rules for entering data and create forms for input.

Also, you'll learn how to extract information in the form of simple queries and reports and export to Excel, PDF and mail merge. Our course also covers database design - essential knowledge when learning to build efficient databases and understanding how they work.

Prerequisite for attending this course:

• Must be comfortable with using a computer.

Microsoft Access Introduction training course outline

Getting Started and Table Design

• Create a new database

• Overview of the Microsoft Access Environment

• Object Naming conventions

• 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

• Delete relationships between tables

• 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

• Work with Operators and Expressions

• 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