| |
| Onsite Microsoft Acces 2007 Training - we come to you! |
| Microsoft Office Training > Office 2007 Training > Access 2007 Intermediate |
 |
Access 2007 Intermediate Training
This
course is suitable for regular
users of Microsoft Access or
those who have a good knowledge
of the topics covered at the beginner's level Microsoft Access course.
The training provides an overview
of advanced queries and table
relationships.
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 |
| Advanced
Queries |
- Revision of select queries
as covered at the beginner's
level
- Parameter queries
- Wildcard queries
- Calculated queries
- Concatenation queries
- Null queries
- Cross-tab queries
- Delete queries
- Make table queries
- Update queries
- Append queries
|
|
|
| Building
Relationships Between Tables |
- Primary keys
- Foreign keys
- One-to-one relationships
- One-to-many relationships
- Many-to-many relationships
- Referential integrity
- Cascade update
- Cascade delete
- Lookups
|
|
|
| Forms |
- Creating multi-table forms
|
|
|
| Reports |
- Creating multi-table reports
|
|
|
|
|
| |
| 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.
|
|
|
|
|
