Microsoft Access

Microsoft Access Training

Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!

Please select the version that you’re interested in

Please select the version that you’re interested in

Microsoft Access 2016 Introduction

Course Overview


This course is designed for new or self-taught Microsoft Access users. It covers all aspects of database design and objects.


No Prior experience or knowledge of databases is required to attend this course. You must have good basic Microsoft Windows, keyboard and mouse skills.


This is a 2 day MS Access Introduction course. The course starts at  09:30  and runs until  16:30Alternate timings can be arranged upon request. The course can be held on a date that suits you.


Our Microsoft Access Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

Access 2016 Introduction Course Outline


Familiarity with access screen

Ribbon and toolbar explanations

Prebuilt database template access and creation

Database Terms Planning

An explanation of databases in general, database objects within access and terminology

Plan your Database (Tables, Queries, Forms, Reports, Macros, Pages and Modules)

Plan a database structure (tables) (normalisation techniques)

Create a new database file


Design a table, conventions for entering naming objects and fields (Design View)

Create a table in datasheet view and edit field names

Select data types and enter field descriptions

Set a Primary Key

Remove a Primary Key

Define field properties (Default values, Input masks, Validation rules and format options)

Insert, Delete, Move and Rename Fields (design view and datasheet view)

Create a table with a wizard

Using the ribbon to set field properties Entering and Editing Data

Accessing objects through the navigation pane

Switch between object Tabs

Switch Views in Access (design, layout and data entry)

Entering and Editing Data (Records & Fields)

Navigating the datasheet

Working in Data Entry Mode

Sorting Data, Finding & Replacing Data

Hiding and Unhiding Fields

Create multiple tables to normalise data Relationships


Different types of relationships

Conditions needed for setting up a relationship

Ensuring Referential Integrity

Printing Relationships in a Report

Insert Sub Datasheets into a table

Change or remove Sub Datasheets from a table

Expand and Contract Sub Datasheets

Enter data in related tables


Create a filter by selection

Create a filter by form

Use AND/ OR options

Save a filter as a select query

Run a Select Query

Build a query from the create ribbon

Creating a query using a wizard

Build a query using the Query Design Window
Adding fields to a query, choose which fields to showRemoving fields from a query

Sort data in a select query

Enter Text, numeric, date, and logic criteria

Enter sub string searches using wild Card Characters

Use the BETWEEN, AND, OR, NOT, NULL criteria in your query

Calculate a field

Concatenate text

Save and name a query

Rename, edit or delete a query Multi Table Queries

Build a query across more than one table

Joining Tables for a query (more relationships)

Setting Join Properties – Inner and Outer Joins

Find Unmatched records Query Wizard

Find Duplicate records Query Wizard


Create a Form using the Auto Form tool Tabular/Datasheet/Pivot Form wizard

Create a Form using the Form Wizard

Create a form in design view

Create a form in layout view

Understand the views and switch between them

Setting data source for a form

Setting the data source using SQL source code

The Field List

Resizing Forms

Control types

Adding controls

Resize and Move Controls

Changing control properties

Selecting Controls

Formatting Controls

Use the Format Painter and AutoFormat

Set basic form properties

Data Entry in Forms

Navigation in data entry view

Add, edit, delete a record in form view


Standard Reports using Wizard

Insert, Move, Size and delete controls

Editing record source

Page setup

Print your report

One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say


This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.