Intermediate Microsoft Access

Intermediate Microsoft Access

The topics covered are as follows:

1      Revision

·        Topics from the Introduction day

·        Revision Exercise

2      More about Datasheets

·        Finding Information in a Datasheet

·        Replacing Information

·        Sorting a Datasheet

·        Filtering for Ad-hoc Enquires

3      Relationships between Tables

·        The Northwind Sample Database

·        Understanding Links

·        Multi-Table Queries

·        Creating the Relationships

4      Custom Forms

·        Starting from Scratch

·        Control Properties

·        Using List / Combo Boxes

·        Check Boxes / Option Buttons

·        Calculations on a Form

5      Custom Reports

·        Starting from Scratch

·        Sorting and Grouping

·        The Control Types to be Used

6      Action Queries

·        Make Table Queries

·        Append Queries

·        Delete Queries

·        Update Queries

7      Macro Design

·        Creating a Macro

·        The Macro Design Window

·        Saving and Running the Macro