Try Access exercises.  Introduction - Intermediate - Advanced

Open CompanyRecords DB. Open Stock DB. Open Relationship Demo DB.

Microsoft Access is a purpose built database package designed to store things such as client details, stock and sales transactions and much more.  Training starts with building simple databases and progresses to complex relational database management.

These outlines are guides only.  Any course can be customised to suit

Introduction
The Database Window
Database Objects
Database Terminology
Creating a Database
Basic Tables
Using Queries
Using the Auto Form Feature
Form Design
Using the Auto Report Feature
Report Design
Copying Data
Freezing Columns
Printing Tables
Printing Reports
Sorting Records
Using the Filter Sorts
Renaming Columns
Using the Chart Wizard

Intermediate
Using the Totals feature
Using Update Queries
Importing 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/Reports

Advanced
Creating Expressions
Creating a Combo Box
Database Protection
Sub Forms
Creating a Switchboard
Advanced Reports/Letters
Calculations across multiple tables
Assign Database Permissions
Adding Calculations to a Report
Basic Macros
Conditional Macros
Creating a Menu Form
Using Action Buttons
Customising a Database
Using the IIF () Function
Properties
Using the DateDiff function
Database Functions