Try Access exercises.  Introduction - Intermediate - Advanced

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

You will cover the following:

Introduction
How to navigate the Database Window
Understand the Database Objects
Understand Database Terminology
How to create an Access Database
Building Basic Access Tables
Creating Access Queries
Using the Auto Form Feature to quickly create wizard based Access forms
How to use Access Form Design feature to create your own Access forms
Using the Auto Report Feature to quickly create Access wizard based reports
How to use Report Design to create customised Access reports
Understanding the slight differences when Copying and Pasting Access Data
How to use the Freeze Columns feature to help with data entry
Learn how to Printing Tables in Microsoft Access
Printing Reports in Microsoft Access
Sorting Records in Microsoft Access
How to use the Filter feature at Table and Form level in Microsoft Access
How to Rename Access Columns
Using the Chart Wizard in Microsoft Access

Intermediate
How to use the Totals feature with Access queries
How to create an Update Query to amend Access tables
How to import an Access Table from another database.
Importing data from an External Data Source such as Microsoft Excel
How to join tables using primary keys in Microsoft Access
Understanding the different types of relationships between Access Tables
How to use Referential Integrity in Microsoft Access
Understand the impact of the three different Join Types in Microsoft Access
How to create a Parameter Query and understand how it affects Access reports
How to create Calculations in Access Queries
Understand the use of Cross Tab Queries in Microsoft Access
Explaining how to use a Delete Query in Microsoft Access
How to create LookUp Lists on an Access Form
How to use the wildcard character within Access queries
Creating an Option group control on an Access form, which will allow multiple selections
How to use the Tab Controls tool within Access forms
How to use Sub Forms/Reports within Access

Advanced
How to create Expressions in Access
How to create a Combo Box in Microsoft Access
Understanding Sub Forms in Microsoft Access
How to create a Switchboard in Microsoft Access
Using Concatenation with Advanced Reports/Letters in Microsoft Access
How to create Calculations across multiple tables in Microsoft Access
How to add Calculations to a Report or a Form within Access
Creating Basic Macros in Microsoft Access
How to use Conditional Macros in Microsoft Access
Creating a Menu Form in Microsoft Access
Using Action Buttons in Microsoft Access
Customising a Database in Microsoft Access
Using the IIF () Function in Microsoft Access
Understand database Properties in Microsoft Access
Using the DateDiff function in Microsoft Access
How to use other Database Functions in Microsoft Access