Introductory Access 365 training – Provisional Course Outline

We are now back to full face-to-face Introductory Access 365 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.

Introductory Access 2016 training

Our Introductory Access 365 training course outlines can be tailored to meet the needs of the individuals or organisation. We train at your site in Dorset, Somerset, Wiltshire and Hampshire.

Aims of the course

This course aims to introduce delegates with little or no understanding of the Microsoft Access software to the basic features of the package.

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

Course Objectives

On completion of the Introductory Access 365 training course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using an MS Access database. They should also be able to create and use tables and forms, and be able to retrieve information from a database using queries and 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 – Delegates attending the Introductory Access 365 training course should preferably have a basic understanding of the Windows environment and use of the keyboard and mouse.

Course Outline

Microsoft Access Database Concepts

  • What is a database?
  • How a database is organised into tables, with records, fields, field data types and field properties
  • Primary keys
  • Indexes
  • Why we relate tables in a database
  • The importance of setting rules to ensure table relationships are valid

First Steps with an Access Database

  • Opening and closing Microsoft Access
  • The Getting Started with Microsoft Access dialog box
  • Opening an existing Access database
  • Creating a new Access database
  • Viewing the Microsoft Access window
  • The Navigation Pane
  • Saving an Access database
  • Using available Help functions
  • Closing an Access database

Adjusting Settings

  • Changing between view modes in a table, form or report
  • Working with the Ribbon


  • Creating and saving a table and specifying fields with their data types
  • Table Templates
  • Adding and deleting records in a table
  • Adding a field to an existing table
  • The Field List pane
  • Field Templates
  • Adding and modifying data in a record
  • Deleting data in a record
  • Using the undo button
  • Navigating within a table to next record, previous record, first record, last record, specific record
  • Deleting a table
  • Saving and closing a table
  • Defining a primary key
  • Indexing a field with and without duplicates
  • Changing field format attributes such as field size, number format, date format
  • Understanding consequences of changing field size attributes in a table
  • Creating a simple validation rule for number, text, date/time, currency
  • Creating column widths in a table
  • Moving a column within a table

Table Relationships

  • Creating a one-to-one, one-to-many relationship between tables
  • Deleting relationships between tables
  • Applying rules to relationships so fields joining tables are not deleted whilst links to another table exist


  • Opening a form
  • Creating and saving a form
  • Using the Form Wizard
  • Using a form to enter, edit and delete records
  • Navigating to next record, previous record, first record, last record, specific record using form display
  • Adding and editing text in form headers and footers
  • Deleting a form
  • Saving and closing a form

Searching and filtering

  • Using the search command for a specific word, number, date in a field
  • Applying a filter to a table or form
  • Removing a filter from a table or form


  • Creating and saving a query using specific search criteria
  • Adding criteria to a query using the operators <, <=, >, >=, =, <>, AND, OR
  • Editing a query by adding or removing criteria
  • Editing a query by adding, removing, moving, hiding, unhiding fields
  • Running a query
  • Deleting a query
  • Saving and closing a query

Sorting records

  • Sorting data in a table, form or query output in ascending, descending, numeric and alphabetical order


  • Creating and saving a report based on a table or query
  • Changing arrangement of data fields and headings within a report layout
  • Grouping data under a specific field in a report in ascending or descending order
  • Presenting specific fields in a grouped report by sum, average, count, maximum, minimum
  • Adding and editing text in report headers and footers
  • Deleting a report
  • Saving and closing a report

Preparing outputs

  • Previewing tables, forms and reports
  • Changing report orientation: portrait or landscape
  • Changing paper size
  • Printing a page, selected records or a whole table
  • Printing all records or specific pages using form layout
  • Printing the results of a query
  • Printing a report of specific pages in a report

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

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

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
Bursledon Denmead Hook Horndean

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

We have also trained home-based businesses and users in some of the Dorset, Wiltshire and Hampshire villages, so please do get in touch.
Clients who have benefitted from our Introductory Access training include:

Really helpful training. Gary explained everything clearly and answered all my questions. Thanks very much.

Abi Stone, Energy Development Services Ltd.