Basic Access Day 2 Training Course

Our Basic Access Day 2 training course can be carried out in all versions of Microsoft.

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 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.

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

Course Objectives

The objective of this Microsoft Access training 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 day 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.

FAQs

Does the training cover the latest Microsoft Office 365 updates?
Yes it does. The content of our Access training courses transfers across and is compatible with any future updates of Microsoft 365. We also regularly review all of our Access 365 training courses to ensure any new features and tools are not missed out.

 

How is the Basic Access Day 2 training course structured?
Our Access training is split up into a 2 day course. The second day covers how to create forms and reports from a database that has been created. This builds on and complements knowledge learnt on the day 1 course. There are 2 short breaks, one mid morning and one mid afternoon, and lunch break planned in to break up the whole day course.

 

How do I know if this is the right level course for my Access training needs?
Day 2 is the complementary course to our day 1 Access course. You will need to have the knowledge of how to create databases from the day 1 course, before you can attend and complete this day 2 course. Day 1 is a pre-requisite for this course as you need the knowledge of how to create a database before you can create forms and reports from a database.

 

How can Microsoft Access training benefit my business?
Access can be the package that is the answer to a businesses problem. It is often used to create a database to hold data in it and then producing reports and forms from that data. It isn’t always a package easy to pick up with no existing training in it, so a course on it will benefit any member of staff greatly. It can strengthen confidence and ability in creating and using these databases as well as developing existing data analysis skills further, helping your business stand out in any industry.

 

Comments and Testimonials

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

LPR – Helping train staff in Excel

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

Fatherson Bakery Testimonial – swapping baking for Excel & PowerPoint!

I worked with John and the team at JPL who created a bespoke training program for us. This was across Excel and PowerPoint to train all our teams up to a standard we needed in the business.

They have developed a Bronze, Silver & Gold 1 day course for us. This allows our team to develop their IT and use practical examples for the their day to day roles.

Feedback has been positive and we look forward to rolling out more with John in the coming months.

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

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.
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