 |
On-Line Computing Maritime House Kingston Street Hull HU1 2DB Tel: 0870 1998 617 |
|
|
MS ACCESS® "HALF DAY USER TRAINING"© |
||
| Attainment Levels | Comprehensive Access training is achieved by attending three incremental courses: Introductory, Intermediate and Advanced. | |
| Duration and Location | Each instructor-led course is approximately half a day in length and has a maximum of only 8 attendees. Courses take place throughout the year in a fully equipped training suite at our Hull city centre offices adjacent to the Ice Arena. Ample free private parking is available. | |
|
COURSE DESCRIPTIONS |
||
| Course title | Introduction to Microsoft Access | |
| Course objective | To provide the attendee with the knowledge and skills required to begin using Microsoft Access | |
| Prerequisites | The attendee must be able to use a Windows-based PC | |
| Topics | Introduction |
What is Microsoft Access? A tour of the screen |
| Creating databases |
Planning and creating
databases Creating a table. Adding, deleting & editing records. Viewing, sorting & finding records. Printing records. |
|
| Restructuring tables | Adding, deleting & resizing fields | |
| Querying | Creating and using select queries | |
| Relationships | Creating relationships | |
| Forms | Creating auto-forms, Viewing, adding & editing records | |
| Reports | Creating auto-reports, Printing a report. | |
| Course Title | Microsoft Access Intermediate | |
| Course Objective | To further the knowledge and skills of those using Microsoft Access | |
| Prerequisites | The attendee must have a basic understanding of Microsoft Access or have attended the Introductory course | |
| Topics | Relationships |
Creating a relationship Querying from several tables. |
| Forms |
Creating a form. Modifying a form. Viewing, adding and editing records. |
|
| Reports |
Creating a report. Modifying a report. Printing a report. |
|
| Introduction to the property sheet | ||
| Introduction to form buttons | ||
| Course Title | Microsoft Access Advanced | |
| Course Objective | To further the knowledge and skills of those using Microsoft Access. | |
| Prerequisites | The attendee must have a good understanding of Microsoft Access or have attended the Intermediate course | |
| Topics | Property sheets | Individual control items option |
| Buttons | Using/modifying | |
| Multi-table forms and reports |
Creating multi-table
forms. Creating multi-table reports Creating sub-forms. |
|
| Advanced querying | ||
| Importing and exporting | Reading and writing other database formats | |
| Macros |
What is a macro? Creating a macro Running a macro |
|
|
|
||
Half Day User Training © On-Line Computing 2005