Basic Access Day 2 Training Course Content

Our Basic Access Day 2 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 first 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 use Forms design and to create macros and reports from an existing database. It complements the first day of our 2 basic Access day courses and is best followed on from attending that course as it will give a good all round knowledge of Access for attendees to create and use their own databases.

Key Content

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

Introduction to the Form Design workplace
Form Design without wizard
Changing Form properties
Adding Controls
Adding fields from a Table
Adding Headers/Footers
Combo and List Boxes. Command Buttons
Adding A Custom Control and performing data entry into the Form
Creating Calculated Controls
Controls to perform an Action
Creating a Macro
Creating a Switchboard
Adding A Subform to a Form
CrossTab Queries
Creating Reports
Exporting into Word & Excel

IKON Dental Suite Testimonial – helping train staff in Microsoft Office

We wanted to share a quick note and let you know that you did a really good job on giving us the training that we need for Excel and PowerPoint.

As we all know these both are big topics which suit every company differently. We cannot thank you enough for taking the time to tailor this course to our needs.

John is an excellent trainer and very generous with his tips. We were also very impressed by the excellent and efficient before and after communication in between us.

The whole team benefitted greatly from the day. We are looking forward booking more courses provided by you.

Read Full Testimonial

Move With Us testimonial – helping train staff in Excel

I had a workshop session with John on a survey report that was taking a considerable amount of time to complete. John explained to us that if we changed how we were initially setting out the data that the production of reports and pivot tables would be much quicker.

The Excel training we had over the course of the next two days was fantastic. John managed to keep us all focussed, he is a very engaging trainer. We were all eager to get back to our desks and start implementing what we’d learnt to make our report running much more efficient.

Read Full Testimonial

Redwing Solutions – Training Staff in Microsoft 365

Both John & Rachel have provided 1-2-1 training for our team for several years and each time the training has been excellent and informative. Recently John & Rachel have been carrying out training for our Kickstart Employee in Word, Excel, PowerPoint & Publisher, which has helped her gain a lot of confidence in using the Microsoft Packages. We were also lucky enough to have John carry out a bespoke Advanced Word course for 2 other members of the team which was in depth and very helpful. Both John & Rachel’s training skills and techniques are fantastic, and they are both extremely patient and conscientious throughout the day, ensuring that everyone understands each section before moving on to the next. We would highly recommend JPL to anyone wishing to get themselves & their team up to date with any IT training!

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

Lime Marketing – delivering bespoke training courses for staff

John has delivered Excel, Word and Outlook training to us at Lime Marketing over the last few months, he has trained around 20 employees and has created bespoke courses to suit our time, money and skill requirements. I’m pleased to say that the individual feedback from our team has been brilliant, everyone has come away feeling more confident and knowledgeable, from a business point of view it is fantastic to see employees valuing and enjoying Johns sessions and most importantly using new skills in the workplace. We look forward to continuing to work with John.

Read Full Testimonial

Basic Day 2 Access Training Course

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

Course Objectives

Key Content

Comments and Testimonials

IKON Dental Suite Testimonial – helping train staff in Microsoft Office

Move With Us testimonial – helping train staff in Excel

Redwing Solutions – Training Staff in Microsoft 365

Direct Air Testimonial – helping train staff in Microsoft 365 packages

Lime Marketing – delivering bespoke training courses for staff

Cookie control