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

Shrewsbury Food Hub Testimonial – training those helping their community

Thank you John for an engaging session. It has opened our eyes to many shortcuts and features that will make our working days run smoother.
Being a small charity, we do a lot of data collection and evaluation, to show the impact of our work. John showed us useful ways to record, sort and display our data in Excel. This will save us a lot of time! Thanks John.
A clear, well-structured course that catered for every level of computer literacy!

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

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

Lime Marketing – delivering bespoke training courses for staff

John has delivered Excel, Word and Outlook training to us at Lime Marketing over the last few months, he has trained around 20 employees and has created bespoke courses to suit our time, money and skill requirements. I’m pleased to say that the individual feedback from our team has been brilliant, everyone has come away feeling more confident and knowledgeable, from a business point of view it is fantastic to see employees valuing and enjoying Johns sessions and most importantly using new skills in the workplace. We look forward to continuing to work with John.

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