Blue Pecan Logo
Office Training
Excel Training Office 2010 Training Project Training Prices Client Feedback Contact
0800 612 4105 mail:
Onsite Microsoft Acces 2007 Training - we come to you!
Microsoft Office Training > Office 2007 Training > Access 2007 Intermediate
Access 2007 Training

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
  • Creating multi-table forms
  • 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.



Copyright (c) 2013 Blue Pecan. All rights reserved. Sitemap