We provide Advanced Access 2013 training at your offices in Wiltshire, Dorset, Somerset and Hampshire. Although a provisional course outline is provided below, all our training can be adapted to meet your needs.

Advanced Access 2013 Training Provisional Course Outline

Aims of the Advanced Access 2013 Training course

This Advanced Access 2013 training course aims to give delegates an insight into some of the more advanced features in MS Access 2013.

Course Objectives

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

  • Normalise data tables
  • Use advanced forms features
  • Use Access in conjunction with the Internet
  • Create advanced queries
  • Produce reports
  • Record and assign macros

The Microsoft Advanced Access 2013 training 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 reasonable knowledge of Access 2013. Prior attendance of the Intermediate Access 2013 course would be an advantage.

Course Outline

Database Design

  • Concepts of Normalisation
  • Junction Tables
  • Microsoft Access naming conventions
  • Indexes
  • Multiple Field Primary keys
  • Data Validation
  • Table Level Validation
  • Field types
  • Join types
  • Lookup fields

Query Types

  • Parameter queries
  • Summary queries
  • Joining tables in queries
  • Cross Products
  • Creating reverse outer joins
  • Concatenation
  • Creating and using a query to update data in a table
  • Creating and using a query to delete records in a table
  • Creating and using a query to save the selected information as a table
  • Appending records to a table using a query

Refining Queries

  • Backing up your database
  • Showing duplicates
  • Showing unmatched values
  • Showing the highest or lowest range of values in a query
  • Parameter queries – allowing query input from a data prompt
  • Refining queries using Null and NOT values
  • IIF Functions
  • Calculating with Dates
  • Querying multivalue fields

Advanced Forms

  • Creating arithmetic and logical expression controls on a form
  • Adding graphics to forms
  • Setting sequential order of controls on a form
  • Creating a subform and linking it to parent
  • Modifying the subform to change records displayed
  • Split forms
  • Creating a Switchboard form

Access 2013 and the Internet

  • How Access 2013 works with the Web
  • Hyperlinks
  • Exporting database object to HTML
  • Importing or linking to an HTML file

Calculations in Reports

  • Applying sorting and grouping to reports
  • Creating arithmetic and logical expression controls in a report
  • Calculating percentages in a report
  • Using formulas and expressions in a report such as sum, count, average, max, min, concatenate
  • Creating running summaries in a report

Macros

  • Recording a simple macro
  • Running a macro
  • Assigning or attaching a macro to a form, report, control
  • Creating an Autoexec macro

Database Management

  • Analysing Performance
  • Compacting and Repairing Databases
  • The Database documenter
  • The Database splitter

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.