Introductory Access 2016 training

We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.

We provide Advanced Access 365 training, delivered at your offices in Dorset, Wiltshire, Somerset and Hampshire. Although provisional course outlines are provided below, all our training can be adapted to meet your needs.

Number on coursePrice per day
1 - 1 training£315 + VAT
2 - 4 people£495 + VAT
5 - 8 people£645 + VAT

Advanced Access 365 Training Provisional Course Outline

Aims of the Advanced Access 365 Training course

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

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 365 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 365. Prior attendance of the Intermediate Access 365 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 365 and the Internet

  • How Access 365 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

To request further details of any of our courses, or to make a booking, please contact us by ringing 01747 820396 or 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.

Microsoft Access training Dorset locations include:

BournemouthPooleSherborneShaftesbury
GillinghamChristchurchFerndownWimborne
Blandford ForumDorchesterWeymouthVerwood
MerleyWarehamBridportLulworth
St Leonards

Microsoft Access training Wiltshire locations include:

SalisburySwindonTrowbridgeChippenham
DevizesMarlboroughWarminsterTisbury
MelkshamWestburyCorshamAmesbury
TidworthBradford-on-AvonBulford CampPorton
CalneHighworthWootton BassettWroughton
Malmesbury

Microsoft Access training Hampshire locations include:

SouthamptonWinchesterPortsmouthBasingstoke
AndoverPetersfieldRingwoodHavant
GosportFarnboroughAldershotRomsey
EastleighFleetAltonFareham
TottonHedge EndStubbingtonBishop’s Waltham

Microsoft Access training Somerset locations include:

BathYeovilWincantonFrome
TauntonWeston-Super-MareMidsomer NortonShepton Mallet
RadstockPaultonBridgwaterBurnham-on-Sea
ChardCheddarClevedonCrewkerne
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.