This course is a follow-on from the Introduction to Microsoft Access course. The course explains how to create some of the more complex queries, forms and reports in Microsoft Access. The courses content is listed below:

Using the Totals feature at table and query level

Using Update Queries

Importing and linking Tables

Importing from an External Data Source

Joining Tables

Table Relationships

Referential Integrity

Join Types

Using Parameter Queries

Calculations in Queries

Using Cross Tab Queries

Using a Delete Query

Creating LookUp Lists

Using the wildcard character

Using Option Groups

Using Tab Controls

Using Sub Forms

Creating Expressions

Creating a Combo Box

Sub Forms

Creating a Switchboard

Advanced Reports/Letters

Calculations across multiple tables

Adding Calculations to a Report

Basic Macros and assigning macros to form controls

Conditional Macros

Creating a Menu Form

Using Action Buttons

Customising a Database

Using the IIF () Function

Form and report Properties

Using the DateDiff function

Database Functions

This course targets intermediate users of Microsoft Access. It is not essential to complete the basic course but it would help in understanding the course details covered in this course. If you would like any of the files used on this course, please get in touch and they will be sent through to you. There are plenty of practise exercises in the accompanying manual.

The basic course covers the main elements of Access, Tables, Queries, Forms and Reports. You will learn how to create table, queries, form and reports.