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

Comments and Testimonials

Microsoft training experts for you | JPL IT Training Limited

John and Rachel developed some customised training to meet a particular need (computer awareness). I was impressed with the service we received from start to finish, the training met our needs and we had extremely positive feedback from the delegates, in particular about the trainers’ style and delivery.

Read Full Testimonial

UCB – delivering all Microsoft Office courses to staff

My colleagues at UCB have nothing but praise for John and his team. John’s training is excellent and his advice on Microsoft packages has been valuable to us. I highly recommend JPL Computer Services Limited as a training provider and look forward to the next training that we will arrange.

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

The SL Shop – Training Staff in Microsoft Excel 365

JPL came out to the SL Shop to give us some Excel training, we were blown away at how much we learnt on the intermediate course. What we have learnt is already being put into action throughout the company to streamline our processes. Advanced course booked and we are very excited. Great courses and an even greater teacher, thanks John.

Read Full Testimonial

MonoSol AF Limited – Helping train staff in Microsoft 365 packages

“We would highly recommend JPL IT Training. We have been using JPL IT Training for several years now and would not consider booking with anyone else.
John and Rachel are excellent trainers and the feedback from employees is always great. They have delivered Excel, Word and Access courses at all levels both face to face and remotely.
The sessions are always interactive and informative, and you leave them knowing much more than you did at the start. In group sessions they have the ability to adapt to each learner and ensure everyone gets the level of attention they need which is important as no one gets left behind”

Read Full Testimonial