| |
| Onsite Microsoft Access 2007 Training - we come to you! |
| Microsoft Office Training > Office 2007 Training > Access 2007 Beginner's |
 |
Access 2007 Beginner's Training
This
course is suitable for complete
beginners or occasional user
of Microsoft Access. The training
will give delegates an introduction
to four main object types in
Microsoft Access: tables, queries,
forms and reports.
To accompany the instructor
lead training, each delegate
will receive manuals and practise,
step-by-step exercises. This
will provide an excellent source
of information and on-going
self study once the training
has been completed.
To view the Office 2007 shared
features topics click
here.
To view Access 2007 upgrade
topics click
here.
For pricing click
here
To return to the application
overview page click
here |
|
|
|
| Course Outline |
| Introduction to
Access |
- Overview of object types
- tables, queries, forms and
reports
- Naming conventions
- The New Navigation Pane
- Tabbed documents
|
|
|
| Tables |
- Fields and records
- Data types
- Field properties
- Lookup fields
- Data entry
- Formatting data tables
- Hiding columns
- Freezing columns
- Filter by selection
- Filter by form
- Importing tables from Excel
- Linking Excel tables
- New Sort and Filter options
|
|
|
| Queries |
- The QBE grid
- Adding fields to your query
- Adding criteria to your
query
- AND criteria
- OR criteria
- Sorting a query
|
|
|
| Forms |
- Creating forms using the
form creation wizard
- Designing your form
- Formatting and placement
of form controls
- The New Layout View
|
|
|
| Reports |
- Creating reports using the
report creation wizard
- Designing your report
- Formatting and placement
of report controls
- The New Layout View
|
|
|
|
|
| |
| Onsite Microsoft Office Training |
Microsoft
Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.
|
|
|
|
|
