  |
|
|
|
Home |
|
Courses/Prices |
|
Qualifications |
|
Contact |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
ACCESS
Corporate | Individual | Tips | SAGE Accounts | SAGE Payroll | ECDL | MOS | Dreamweaver | Centre Locations
|
Beginner
|
Intermediate
|
Advanced
|
|
| Duration | 10 hours | 12 hours | 20 hours |
| Suitable for | People with little or no database experience | People with some database experience | People with good database experience |
| Pre-requisites | Microsoft Windows 95 / 98 introduction course. Keyboard skills | Access 2000 Beginners course or similar skill level | Access 2000 Intermediate course or similar skill level |
| Course objectives | To teach the essential features of this database package for work or home use. | To have the expertise to set up a database and use it effectively | To set up and use some of the more advanced aspects of the Access database |
| Course outline |
Introduction - key concepts· Getting started· The Office Assistant· Navigating the database· Changing & adding records· Filtering records - by selection, using an expression and by form· Understanding the database · Tables - finding, filtering, editing, adding and deleting records· Querying the database· More about Queries - action, make table and update queries· Reports - AutoReport and report wizard· Managing a database - backing up, compacting and repairing |
· Database wizards· The international contacts database · Creating a database table - planning, opening and table wizard· Changing the table design - field properties, indexes, input mask and number data type· Creating a form - AutoForm, adding new records and form wizard· Changing the form design - sections of a form, controls and labels, form properties· Combo boxes· Entering and importing data · Adding tables· Creating relationships· Producing mailing labels· Creating a switchboard |
Forms & subforms· Forms - expressions· Calculations in queries· Parameter queries· Crosstab queries· Append & delete queries· Report design· Reports - expressions, totals & parameters· Reports & subreports· Command buttons· Events & macros· Mail merge |
| Follow on courses | Access 2000 Intermediate | Access advanced course | Other Microsoft Office courses |
|
|
 |
 |
|
 |
|
 |
|
 |