Basic Access Day 1 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
For more information and for prices, please contact us at johnlegge@jplcomputer.co.uk or by giving us a call on 07903 840105 for a no obligation quote.
We’d be happy to help with your Microsoft Office training needs.
Comments from attendees:
“Perfect introduction and overview of Access from start to functioning switchboard. Best part of the course: explanation of how database works and how links between tables work”
“Comprehensive, I will be able to re-read! (course notes). Best part of the course: John’s patience and step-by-step guidance”
“Sometimes found it difficult to keep up but John was always helpful. Best part of the course: learning the general outlook of the programme”
“Best part of the course: depth of the information provided, lively presentation”
“Best part of the course: ease of interactions”
“Best part of the course: plenty of exercises rather than being talked at”