Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

 Live online  Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
 I would like to receive software tips and special offers

Testimonials

Handelsbanken

I am very impressed with the training. My access skills are very much self taught and I was unsure about whether the level of the course would be right. The training was delivered in a really clear manner and at the right pace. Thank you very much to Richard for the course. I would thoroughly recommend it.

Blaby District Council

"I found the training session really interesting as I use Access daily and had no idea on how much it actually can do. Simon is a fantastic trainer and takes his time explaining all the background so you get to understand better, he is thorough and has the patience of a saint. I would highly recommend anyone considering this training to consider going booking Simon and his team."

British Antarctic Survey

"Our bespoke training was really good and invaluable. We learnt a great deal about Microsoft Access and databasing techniques. Both aspects are so important to our work. Simon, our trainer, was a real expert and he made the two days interesting and enjoyable. Thank you so much"

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

Microsoft Access 2019 Training Course Beginners

Beginners Microsoft Access 2019 Course Overview

Data Management is part and parcel of many job roles. The Microsoft Access database application can help and your organisation manage data with ease and efficiency.

What You'll Learn in this Access Beginners Training Day

  • Create a simple database
  • Customize Access configuration options
  • Organize and manage data within Access tables
  • Use queries to join, sort, and filter data from different tables
  • Use forms to make it easier to view, access, and input data
  • Create and format custom reports

Course Duration: 1 Day

Course Prerequisites

This is a Beginners training course and hence has a minimal of course prerequisites from each individual student. These are as follows:

  • The ability to use a PC or Mac (Use of the mouse or equivalent interface device)
  • Familiarity with the current version of Windows
  • Able to use the Internet and download files
  • The use of a PC or Mac throughout the training day

Complete Course Outline

Getting Started with Access 2019

  • Launch Access and open a database
  • Use tables to store data
  • Use queries to combine, find, filter, and sort data
  • Use forms to view, add, and update data
  • Use reports to present data
  • Get help and configure options in Microsoft Access

Creating Tables

  • Plan an Access database
  • Start a new Access database
  • Create a new table
  • Establish table relationships

Creating Queries in Access 2019

  • Create basic queries
  • Perform calculations in a query
  • Sort and filter data in a query

Creating Forms

  • Start a new form
  • Enhance a form

Creating Reports

  • Start a new report
  • Enhance report layout

Other Related Courses

All Microsoft Access Training Courses

Microsoft Access 365 Training Course Beginners

Microsoft Access 365 Training Course Advanced

Microsoft Access 2019 Training Course Intermediate

Microsoft Access 2016 Training Course Intermediate

Microsoft Access 2016 Training Course Intermediate

Post-Course Resources

  • Training notes & exercise files
  • Online materials: video tutorials & shortcuts
  • 3 months post training support

All you need to know about our Live Online Training.

Live Online Training