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.

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

Comments and Testimonials

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

Microsoft Office Access – supporting your business development

John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.

Read Full Testimonial

Build It International testimonial – helping those that help others

Thanks to @johnlegge for our recent Excel training session helping us to manipulate data quicker and more effectively 📊📈 Lots of really useful hints and tips that we’ve already been putting into practise! #MasterYourData 🤓 #BuildingBrighterFutures

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

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