All our training courses can be designed to suit your company's needs. Take a look at all the different features that separate us from other Access 2000/3 Intermediate training courses.
Objectives:This course provides Intermediate level of training.
Who should Attend:Delegates who have attended the introductory course.Course objective is to improve upon Access Database Usage & Design.
Duration : 1 day
Course Content
| |
CREATING & ENHANCING DATA ENTRY FORMS
|
 |
Queries & Forms |
 |
Placing Fields |
 |
Adding Controls |
 |
Unattached Labels |
 |
Sizing & Moving Text |
 |
Tab Order |
 |
Adding Memo Controls |
 |
Yes/No Fields |
 |
Toggle Buttons |
 |
List & Combo boxes |
 |
Adding Objects |
 |
Locking Forms |
 |
Calculated Fields |
 |
Formatting Buttons |
 |
Adding Lines & Rectangles |
 |
Adding Effects
|
| |
FORM HEADERS & FOOTERS
|
 |
Adding Option Buttons |
|
| |
ADVANCED QUERY TYPES
|
 |
Calculated Queries |
 |
Parameter Queries |
 |
Action Queries |
 |
Append Queries |
 |
Delete Queries |
 |
Unmatched Record Queries |
 |
Update Queries |
 |
Make Table Queries
|
| |
MAILMERGE
|
 |
Mailmerge to Word Document |
 |
Mailmerge to Labels
|
| |
BACKING UP & REPAIRING DATABASES
|
 |
What to Backup |
 |
Repairing a Database |
 |
Compacting Databases |
|
|