» Course Overview

This course is suitable for new, recent or intending users of Access who have little or no existing database knowledge

Hand on with Microsoft Access :
Tables  (tbl)– create tables that contains:
tblEmployees
tblProducts
tblSuppliers
tblCustomers

In this exercise you will extent and improve tables by adding additional fields you feel necessary.

1. set field properties to determine whether any field would benefit from required entry, input masks etc
2. create indexes, set indexes as appropriate, save the changes as you work
3. look at table documentation, use the documenter facilities to view the field properties of existing tables
4. table lookup: consider each field to ascertain whether data entry could be by the use of combo lists.

You then progress in hand on queries etc.