Basic Access Day 1 Training Course

Our Basic Access Day 1 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 second 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 this Microsoft Access Training Course can be found below:

 

  • Introduction to databases and glossary of terms
  • Creating simple Tables using Design mode
  • Fields, data types, keys
  • Simple validation
  • Creating multiple tables and basic Relationships between tables
  • Entering Data into a table using Datasheet mode
  • Data Integrity and Validation
  • Saving and printing
  • Simple sorts and filters within a table
  • Creating simple queries
  • More complex queries including totals and calculations

Course Objectives

The objective of this Microsoft Access Training Course is to enable the trainee to create a simple database using Tables, Relationships and Queries. This is the first day of our 2 Basic Access day courses. This first day will give trainees a good introduction to databases looking at glossary of terms too.

FAQs

How is the Basic Access Day 1 training course structured?
Our Access training is split up into a 2 day course. The first day covers topics to enable trainees to learn the basics of how to create a database. There is also a mid morning break, lunch break and mid afternoon break planned in to make sure that it isn’t too much information for you in one go.

 

Does the training cover the latest Microsoft Office 365 updates?
Definitely. The content of our Access training courses transfers across and is compatible with any future updates of Microsoft 365. As well as this though, all of our Access 365 training courses are reviewed regularly to ensure any new tools and features are not missed out.

 

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

 

How do I know if this is the right level course for my Access training needs?
As our Access training is split up into a 2 day course, both levels would be the right level for your needs. We strongly recommend attending both of these courses to have a good round understanding of the package to then be able to use it effectively in your job. Day 1 would need to be completed before going on to Day 2.

 

Comments and Testimonials

Microsoft Excel Courses at AFH Wealth Management

John is an excellent trainer and has helped many of our staff members become competent users of Excel, which has ultimately improved efficiencies when performing their job roles. John’s “learn by doing” style of teaching is very effective as it enables the trainees to get hands-on experience while they develop their skills within the system.

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

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

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

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