Course Outline:

Module 1 (Day 1) Creating a Database Creating a new database The database elements Creating a Data Table Setting field properties Using input masks Setting validation rules Assigning default values Setting a primary key Creating lookup fields Working with Data Tables Adding data Deleting data Sorting data Data entry quick keys Filtering Creating Simple Data Forms Using the form wizard Building and amending forms Entering data Extracting Data Using Queries Creating select queries Setting criteria Creating parameter queries Adding calculations to queries Printing and Reporting Printing tables and queries Using the report wizard Building and amending reports Error checking (2003 and 2007 only) Changing the Report in Layout View (2007 only)

Module 2 (Day 2) Principles of Relational Databases Importing Data Importing data from Excel Building Relational Databases Linking information between tables One to one and one to many links Defining referential integrity Printing table relationships Sub Datasheets Viewing a subdatasheet Adding a subdatasheet Building Multi Table Queries Creating multi table queries Links within queries Join properties Advanced Form and Report Design Field properties Adding calculations Adding headers and footers Adding dates, times, page numbers Sorting and grouping Concatenating fields Case Study