Microsoft Access Software Training

About Microsoft Access

Storing large amounts of data? Wondering how to find what you need, and get the data into a presentable format?

We’ll show you how to create, administer and extract data from Microsoft Access databases. Along the way you will learn how to optimise the databases you might already be using, protect them, get clearly presented output, and link the databases with other applications such as Excel and Word.

Each level of training takes one day to complete.

Microsoft Access

Course Outlines

Microsoft Access Introduction

De-mystify the database world in the comfort of your own work place! Learn terminology and how to create a functioning database to store your information. Create simple, clean data input screens and find and display information in attractive on-screen and printed formats. Prevent incorrect or invalid data from being input, and to ensure consistency of data.

Creating a database
Understanding database terminology
Tables and properties
Importing data from Excel and other formats
Creating Forms to input and view data
Creating and running queries
Designing reports for printing

Microsoft Access Intermediate

Streamline databases by creating relationships between tables to cut down the amount of data required. Update or delete data in tables automatically. Automatically calculate other values in forms and reports. Make your database attractive, safe and easy to use by others, using a menu system. Prevent accidental deletion by others. Run powerful combined actions using menus.

Creating table relationships
Viewing database relationships
Advanced queries
Action queries
Calculated fields
Creating a menu system
Protecting important database elements
Macros
Assigning macros to menus and form controls

Microsoft Access Bespoke / Tailored

Build your own course by selecting topics from three levels, or adding your own!

Get in touch for more information.

Course Delivery Options

ONSITE Learning

Learn in the comfort of your own workplace, both individually and in small groups of colleagues.

Each course is delivered by an experienced, qualified instructor who is on hand to help individual learners as well as guiding the group with hands-on examples and exercises.

Each course can be personalised to meet the individual needs of the business and the trainees

Duration: 1 day per level

REMOTE Learning

Learn with the convenience of remote meeting technology such as Teams or Zoom.

With the benefit of two screens each learner will feel involved, and the live training delivers the same quality of training as the in-room experience of trainer/delegate interaction.

The trainer will deliver the training live, with each demonstration on one screen, taking the trainee through the examples step by step on their own screen.

Each course can be personalised to meet the individual needs of the business and the trainees.