Access 2003 Advanced

This course is for anyone who wishes to become an expert user of Microsoft Access.

Aims

By the end of this online course you will be confident in using Access to an advanced level.

What you will learn

This course will cover the following topics:

Creating and Editing Tables: Creating tables; Editing tables; Creating lookups; Changing field properties.

Relational Databases – One-to-Many: What are relationships?; Creating a one to many relationship; Creating main and subforms for a one to many relationship; Editing relationships.

Relational Databases – One-to-One: What is a one to one relationship?; Creating a one to one relationship; Creating main and subforms for a one to one relationship.

Relational Databases – Many-to-Many: What is a many to many relationship?; Creating a many to many relationship; Creating main and subforms for a many to many relationship; Editing a subform.

Requirements

Delegates must be confident in using a keyboard, Windows and a mouse and in the basic features of Access.

How the online course works

The online modules are structured as follows:

How it works

Here you can find out about how our lessons are structured, the style of training we use, and guidance on some of the features you will find in our lessons.

Course materials

Here you will find the manual and the demo files you need to complete the lessons.

Complete the preassessments

Here you can choose a preassessment to assess which lessons you need to take. The preassessments can be taken in any order you wish.

Start lessons

Here you will find the full list of lessons for that module.

Your learning plan

Here you will find lessons that have been added to a structured plan for you based on the results of the preassessments. You can also manually add and remove lessons from this plan.