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

Redwing Solutions Ltd – Training staff in Excel, Word and PowerPoint

JPL’s training courses have been brilliant for us. John delivers the courses in an informative, helpful and extremely friendly manner.
Each element of the courses is explained clearly and makes sure that everyone understands before continuing. Each course is gone through at your own pace, so it never feels rushed or overwhelming.
Furthermore, John is always personable and makes sure the courses are always an enjoyable and friendly experience.

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

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

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

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