Training advisors available Mon–Fri, 9am to 5pm train@keystraining.com Public course dates
Speak to an advisor0345 450 0051 Build a quote
Microsoft 365 & Copilot

Microsoft Access

Build powerful databases the right way

Hands-on, instructor-led Access courses: delivered at our training venues or at your premises, teaching the correct way to set up, run and develop databases.

Length1 day
LevelAll levels
FormatsIn-house · Public
Group sizeUp to 8 per group
Get a quote for your team
Overview

About the Microsoft Access course

Microsoft Access can be used to build powerful databases with relatively little effort. It is extremely versatile, and applications can range from linking simple data lists to fully functional accounts and invoicing systems.

Our Access training courses take you from the fundamentals of good database design through to advanced querying and reporting of data, and we are happy to customise any company Access course to include the topics that best meet your needs.

  • Two levels: Introduction and Intermediate
  • Public courses at our venues, or onsite at your premises
  • Free post-course telephone & email support
Tables

Design tables, set data types and assign primary keys.

Queries

Find, calculate and update data with select and action queries.

Forms & reports

Create forms for data entry and reports that group and sort data.

Importing data

Bring data in from Excel and other sources.

Choose your level

2 courses, one day each

Not sure which level? Ask for our free pre-course evaluation form and we’ll recommend the right level for each person.

Level 1IntroductionLevel 2Intermediate
Course outline

What the day covers

2 modules · tailored to your team on in-house courses
Access Introduction6 topics
  • Access basics: the Access window, database terminology and Access objects
  • Relationships and the function of the primary key
  • Database tables: entering, editing, sorting, filtering and finding data
  • Data types and designing a new table
  • Query use and design
  • Creating and modifying forms and reports
Access Intermediate6 topics
  • Review of Access basics
  • Database design: data types, field properties, primary keys and relationships
  • Importing data
  • Parameter queries, calculations and action queries (make table, append, delete, update)
  • Forms with subforms and the form controls toolbox
  • Reports with calculations, grouping, sorting, labels and graphics
Courses & fees

Ways to book this course

Level 1

Access Introduction

£225+ VAT
1 day · per delegate (public course) · View Course Outline · Level 2
  • Onsite: £645 + VAT, up to 8 attendees
  • Access basics and database tables
  • Queries, forms and reports
Request a quote
Option

Access Intermediate

£225+ VAT
1 day · per delegate (public course) · View Course Outline
  • Onsite: £675 + VAT, up to 8 attendees
  • Database design, relationships and importing data
  • Parameter, calculated and action queries
Request a quote

Public course prices are per delegate. Onsite prices are per course for up to 8 attendees. View scheduled course dates or see our volume discounts.

Every course includes

More than just a training day

Dedicated account managerOne named contact who knows your organisation and your history with us.
Pre-course evaluationFree skills check forms so every delegate lands on the right level.
Course tailoringWe plan and customise closed courses around your roles, systems and files.
CertificatesA Keys Training certificate for every attendee, for training records and ESR.
Management feedbackPost-course feedback reviews so you can see what landed.
Free aftercareTelephone and email support for every delegate after the course.
Good to know

Frequently asked questions

Which Microsoft Access course is right for me?

Access Introduction is for new users and covers database terminology, tables, queries, forms and reports. Access Intermediate builds on this with database design, field properties, relationships, importing data, parameter and action queries, subforms and more advanced reports.

Why attend an Access course rather than teach yourself?

Microsoft Access is one of the more advanced programs in the Microsoft Office suite and needs to be set up and used in the correct way. Although it is possible to self-teach up to a point, not following best practice can have serious consequences once a database is in use. On a Keys Training course, delegates learn the correct way to set up, run and develop databases, with reduced fear of problems occurring in the future.

Can an Access course be customised for our team?

Yes. We are happy to customise any company Microsoft Access course to include the topics that best meet your needs. Courses can be held at your premises or at one of our venues in Preston, Manchester, Liverpool, Leeds and London. View scheduled course dates.

Ready to get your team working smarter with Access?

View upcoming scheduled dates, or speak with a training advisor to arrange an Access course for your team.

Email an Enquiry

Or call us on 0345 450 0051 to speak with one of the team today.

Keep going

Courses that pair well with this one

All microsoft 365 courses

Get your team trained properly.

Tell us the course, rough numbers and where you are. A training advisor will reply within one working day with options and a fixed fee.

Build your quote or call a training advisor0345 450 0051
From£645 + VAT per group of up to 8Get a quote
View quote