Basic Access Training Course

Our Basic Access Day 1 training course can be carried out in the following versions: 2010, 2013, 2016 and 365.

All of our courses are full day courses, typically running from 9:30am to 4pm with two coffee breaks and a lunch break throughout to break up the course. Timings can be slightly flexible though to fit in with your needs.

We can also bespoke the content alongside the second day course content to make it a 1 day course, just with less content on each of the topics. Just ask, we’d be happy to help.

Course Objectives

The objective of this course is to enable the trainee to create a simple database using Tables, Relationships and Queries. This is the first day of our 2 Basic Access day courses.

This first day will give trainees a good introduction to databases looking at glossary of terms too.

Key Content

The key content that is covered in the course can be found below:

• Introduction to databases and glossary of terms

• Creating simple Tables using Design mode

• Fields, data types, keys

• Simple validation

• Creating multiple tables and basic Relationships between tables

• Entering Data into a table using Datasheet mode

• Data Integrity and Validation

• Saving and printing

• Simple sorts and filters within a table

• Creating simple queries

• More complex queries including totals and calculations