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 Microsoft Access training 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 Microsoft Access Training 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 this Microsoft Access Training 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

Comments and Testimonials

Shrewsbury Food Hub Testimonial – training those helping their community

Thank you John for an engaging session. It has opened our eyes to many shortcuts and features that will make our working days run smoother.
Being a small charity, we do a lot of data collection and evaluation, to show the impact of our work. John showed us useful ways to record, sort and display our data in Excel. This will save us a lot of time! Thanks John.
A clear, well-structured course that catered for every level of computer literacy!

Read Full Testimonial

Rea Valley Tractors – Excel training courses to enhance staff skills

John delivered the session in a relaxed manner. He ensured that all abilities were catered for and that people were learning at their own pace.
For the employees that needed a little more time, they did not feel pressured to move on and for the employees that were a little more advanced, John demonstrated some great tips and tricks!!
The day sessions were interesting, enjoyable and well planned. We can totally recommend this course and have booked for future intermediate training and an advanced bespoke course.

Read Full Testimonial

Direct Air Testimonial – helping train staff in Microsoft 365 packages

JPL IT Training has provided exceptional remote training for members of our Sales & Marketing team. The team had varying levels of Microsoft knowledge, so the training covered Word, Excel and PowerPoint. All of the team found the courses they attended really useful. As a result they have been implementing key takeaways in their day-to-day work such as shortcuts and formatting tools. The training was 1-2-1 and very flexible to each learners’ requirements. This style was a fantastic method of training for our business. Thank you to John & Rachel!

Read Full Testimonial

Ashorne Hill – Training staff in Excel, Word and PowerPoint

Excellent training delivery, courses being small in numbers worked very well for our staff, giving them time for any additional questions/content.
Smooth process from start to finish and excellent that trainers could provide individual laptops for staff that didn’t have their own.
Very informative training – we like the fact we can keep notes to refer back to while at work

Read Full Testimonial

Woodgreen – Helping pets and their people – Bespoke Access training course

We were looking for a tailored Access database training course and John was able to accommodate our requirements with ease and offer flexibility which was just what we wanted.
The pace of the training was spot on. It was informative and interactive and we felt comfortable in asking questions.
John was very patient and we all learnt a lot. The day just flew by which just shows how much we enjoyed the day and the content and support given. Thank you John!

Read Full Testimonial