Basic Access Training Course Day 2

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

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.

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.

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

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

Caldwell UK & Cotswold Architectural Products Ltd – Training Staff in Microsoft 365

We have used JPL training throughout the past year to help improve our teams Excel skills, and we all really enjoyed the training. Both online and on site.
John and Rachel show great patience and can really pin point individual needs. All of our departments have benefited from the training, and we are already looking for our next opportunity to extend our skills with JPL.

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

Chamber of Commerce – Excel Training for Forest Garden Group

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

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