| Course Code |
AC-3 |
| Description: |
Advanced techniques in Access 2003 for Windows. |
| Aim: |
To introduce advanced concepts and techniques for using Access
2003 for
Windows. |
| Duration: |
1 day non-residential. |
| Pre-Requisites: |
Delegates should have a good understanding of
the principles and techniques associated with Access 2003 for Windows
Introductions and Intermediate courses before attending this course. A 3 month
gap is required between completion of the Intermediate (AC-2) course and
attendance of this course. |
| Designed For: |
Staff who are required to use Access 2003 in the
course of their work and who wish to build on the skills gained in the
Introduction (AC-1) and Intermediate (AC-2) courses. |
| Cost for Non MoD Applicants: |
The cost of this course is £225.00 excluding VAT. Details of payment options will be sent in a confirmation e-mail when you apply for the course. |
| Post Course Exercise: |
|
| Objectives: |
By the end of the course delegates will be able to:
• Crosstab Queries;
• Use Main/Sub Forms including Combo Boxes and Option Groups and Tab Controls;
• Create graphs;
• Use replication;
• Data access pages;
• Switchboard manager;
• Splash screen/start up;
• Compact and repair/ performance analyzer/documenter;
• Use Macros: Command Buttons, Menus, Conditional. |
| Related Learning: |
• Access 2003 for Windows – Introduction (AC-1);
• Access 2003 for Windows – Intermediate (AC-2). |