Intermediate Microsoft Access 2003 Training Courses

If you’re looking for really great Intermediate Access 2003 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Intermediate Access 2003 training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

  • We come to you - your Microsoft Access 2003 training will be given on your site
  • You get to keep the manuals - Intermediate Access training manuals are provided as PDFs
  • We can train using your own Microsoft Access databases
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Request Course Now »

Course TypeCost per day
1 to 1 training £275
2 to 4 delegates £425
5 to 8 delegates £550

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £550. All prices exclude VAT

Other Microsoft Access training courses

Aims of the Intermediate Access 2003 course

This course aims to give delegates a greater understanding of MS Access 2003.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Access 2003. They will be able to:

  • Use field properties for protection
  • Understand table relationships and referential integrity
  • Create multi-table queries
  • Use calculations in a query
  • Design custom entry forms
  • Design custom reports

The course is of one day's duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a basic knowledge of MS Access 2003.

Access Database Design

  • Primary and Foreign Keys
  • Relationships

 Using Field Properties for Protection

  • The Required property
  • Default Values
  • Input Masks
  • Validation Rules and Validation Texts
  • Lookups

 Table Relationships

  • Relationships Defined
  • Relationship Types
  • How to Create and Edit Relationships
  • Using Lookups for Referential Integrity
  • Multi-Table Datasheet view 

Access Queries

  • Multi-table Queries
  • Adding Calculated Fields to Queries

Access Forms

  • Form Sections
  • Form Controls
  • Layout of Form Controls
  • Properties of Form Controls
  • Control Wizards
  • Introduction to Multi-Table Forms

Access Reports

  • The Microsoft Access Report Wizard
  • Report Sections
  • Report Controls
  • Layout of Report Controls

Importing Data from Other Sources

Using Microsoft Access 2003 Tools

  • Backing up and restoring a database
  • Compacting and repairing a database

Request Course Now »

We provide Microsoft Access training courses, Microsoft Office training courses, other IT training courses  and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Intermediate Microsoft Access 2003 training courses Sydney, Australia, please visit our sister site at http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training/intermediate-access-2003-training