|
Course aim
This course is an overview of the relational database, Microsoft Access
2003.
Who should attend?
Delegates should be familiar with the Windows environment. No prior knowledge
of database terminology or Microsoft Access is assumed. The course includes
no programming.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
| |
Course contents
The Access Environment
Introduction to database terminology
Starting Access and opening a database
Database objects
Online help
Creating New Databases and
Tables
Planning a new database
Creating a new database
Creating a database table using the Wizard
Creating a database table in Design View
Setting field properties
Setting up primary Keys
Moving around a table and entering data
Copying, moving and deleting data
Locating, sorting and filtering data
Using the LookUp Wizard to link tables
Designing Forms
Why create a form?
Types of form
Using AutoForm
Using the Form Wizard
Changing forms in Design view
Adding fields to forms
Form and control properties
|
Using Select Queries
What is a query?
Creating a query using the Wizard
Creating a query in design view
Saving and printing queries
Queries with multiple tables
Calculations and summaries in queries
Reporting
Printing from Datasheet view
Using AutoReport
Using Report Wizards
Label reports
Modifying reports in Design view
|
|
