Access 2003 - Course List
-
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.
2 days
ACC-03-01
-
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.
2 hours
ACC-03-02
-
Design simple forms to ease the input and display of information held in the database.
2 hours
ACC-03-03
-
Create simple queries to find information in a database
2 hours
ACC-03-04
-
Extract information from the database with reports. Use the wizard to create simple reports. Edit the properties & controls.
Half day
ACC-03-05
-
How to find and view information in a database through the use of existing forms, queries and reports.
2 hours
ACC-03-06
-
Create effective forms using some of the more advanced form design features.
Half day
ACC-03-07
-
Understand the types of query available. Build queries that manipulate or archive the data in a database.
2 hours
ACC-03-08
-
A look at the more complex reporting options. Enhance reports with the use of graphics/charts and subreports.
Half day
ACC-03-09
-
An overview of the VBA language in Access.
2 days
ACC-03-11
-
Apply security to a database and understand security files.
Half day
ACC-03-12
-
A session to cover any aspects of Access.
1 hour - 1 day
ACC-03-13