Access 2003
Excel 2003
FrontPage 2003
Outlook 2003
PowerPoint 2003
Project 2003
Publisher 2003
Web
Windows XP
Word 2003
Access 2003 - Course List
| n |
Introduction |
2 Days |
| |
The course is designed to introduce users to the basics of Access and to enable them to create a database from scratch to include basic input forms, queries and reports.
Ref: ACC-03-01 |
|
|
|
|
|
| n |
Using Forms and Data Input |
2 Hours |
| |
Learn to navigate an existing database. Use forms to search for, add, edit and delete information. Incorporates module: ACC-03-06 Access 2003 Viewing & Searching a Database.
Ref: ACC-03-02 |
|
|
|
|
|
| n |
Form Design Basic |
2 Hours |
| |
Design simple forms to ease the input and display of information held in the database.
Ref: ACC-03-03 |
|
|
|
|
|
| n |
Queries Basic |
2 Hours |
| |
Create simple queries to find information in a database
Ref: ACC-03-04 |
|
|
|
|
|
| n |
Reports Basic |
Half Day |
| |
Extract information from the database with reports. Use the wizard to create simple reports. Edit the properties & controls.
Ref: ACC-03-05 |
|
|
|
|
|
| n |
Viewing & Searching a Database |
2 Hours |
| |
How to find and view information in a database through the use of existing forms, queries and reports.
Ref: ACC-03-06 |
|
|
|
|
|
| n |
Form Design Advanced |
Half Day |
| |
Create effective forms using some of the more advanced form design features.
Ref: ACC-03-07 |
|
|
|
|
|
| n |
Queries Advanced |
2 Hours |
| |
Understand the types of query available. Build queries that manipulate or archive the data in a database.
Ref: ACC-03-08 |
|
|
|
|
|
| n |
Reports Advanced |
Half Day |
| |
A look at the more complex reporting options. Enhance reports with the use of graphics/charts and subreports.
Ref: ACC-03-09 |
|
|
|
|
|
| n |
Macros |
1 Day |
| |
Automate a database using macros and a switchboard form.
Ref: ACC-03-10 |
|
|
|
|
|
| n |
Database Security |
Half Day |
| |
Apply security to a database and understand security files.
Ref: ACC-03-12 |
|
|
|
|
|
| n |
Workshop |
1 Hour-1 Day |
| |
A session to cover any aspects of Access.
Ref: ACC-03-13 |
|
|
|
|
|
|
