We provide Intermediate Access 2016 training in your offices in Wiltshire, Dorset, Somerset and Hampshire. Although a provisional course outline is shown below, all our training can be adapted to your needs.

Intermediate Access 2016 Training Provisional Course Outline

Aims of the Intermediate Access 2016 Training course

This Intermediate Access 2016 training course aims to give delegates a greater understanding of MS Access 2016.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Access 2016. 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.

Provisional Course Outline

Displaying the Access 2016 database

  • The Navigation pane, customising the Navigation pane
  • Database display

Table design – fields

  • Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Creating and editing a lookup in a field
  • Creating and editing a validation rule in a field
  • Creating and editing an input mask in a field
  • Applying and modifying default values in a field
  • Setting a mandatory field
  • Fields with multiple values

Table Relationships

  • Understanding the basis for creating a valid relationship
  • Creating a one-to-one or a one-to-many relationship between tables
  • Understanding and modifying a many-to-many relationship between tables
  • Applying inner, outer and self joins
  • Applying and using referential integrity
  • Applying automatic deletion of related records
  • Relating or joining data when designing records
  • Adding fields to tables
  • Field templates

Microsoft Access Query design

  • Grouping information in a query
  • Using a crosstab query
  • Using wildcards in a query
  • Using arithmetic and logical expressions in a query

Form design

  • Using bound and unbound controls
  • Creating and editing a combo box, list box, check box and option groups
  • Inserting a data field to appear within form header or footer on the first page or all pages
  • Stacked and tabular layout controls

Report design

  • Inserting a data field to appear within report header or on footers on the first page or all pages
  • Forcing page breaks for groups on reports

Importing, exporting and linking data

  • Importing text, Excel, csv, etc documents into an Access 2016 database
  • Exporting data in Excel, txt, and other formats
  • Linking external data to an Access 2016 database

Microsoft Access training Dorset locations include:

Bournemouth Poole Sherborne Shaftesbury
Gillingham Christchurch Ferndown Wimborne
Blandford Forum Dorchester Weymouth Verwood
Merley Wareham Bridport Lulworth
St Leonards

Microsoft Access training Wiltshire locations include:

Salisbury Swindon Trowbridge Chippenham
Devizes Marlborough Warminster Tisbury
Melksham Westbury Corsham Amesbury
Tidworth Bradford-on-Avon Bulford Camp Porton
Calne Highworth Wootton Bassett Wroughton
Malmesbury

Microsoft Access training Hampshire locations include:

Southampton Winchester Portsmouth Basingstoke
Andover Petersfield Ringwood Havant
Gosport Farnborough Aldershot Romsey
Eastleigh Fleet Alton Fareham
Totton Hedge End Stubbington Bishop’s Waltham
Burlesdon Denmead Hook Horndean
Blackfield

Microsoft Access training Somerset locations include:

Bath Yeovil Wincanton Frome
Taunton Weston-Super-Mare Midsomer Norton Shepton Mallet
Radstock Paulton Bridgwater Burnham-on-Sea
Chard Cheddar Clevedon Crewkerne
Glastonbury

We have also trained home-based businesses and users in some of the Dorset, Wiltshire and Hampshire villages, so please do get in touch.