Module 1
Introduction to a relational database?
Designing tables
The toolbar
Creating table objects
Primary keys and foreign keys
Table definition components
Setting field properties
Set rules and validations
Set default values
Creating indexes
Module 2
Modifying table structures
Entering data in datasheet view
Importing data
Creating relationships and setting up referential integrity
Modifying displayed data
Copy move and delete data
Hide and show data
Module 3
Searching tables
The find command; limitations of find
Find and replace
Using filters, Selection and Form
Using Wild Cards to set criteria
Setting multiple levels of criteria
Excluding a set of records
Module 4
Designing data entry forms
Auto Form, and Form wizard
The form design work surface
The object property sheet
The palette
The field list
The toolbar
The toolbox
Creating multi-table forms
Module 5
Designing Queries
Setting Criteria
Parameter Queries
Calculation in queries
Summarising data
Table joins in queries
Action Queries
Updating queries
Make table queries
Delete queries
Append queries
Module 6
Printing tables and forms
Working with reports
Single column and tabulated reports
Groups and totals reports
Mailing labels
Redesigning existing reports
The report bands
Integrating with Microsoft Word
<< Back to Tutoured Courses
