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 · Intermediate

Access Intermediate

Microsoft Access Intermediate Training

Closed tailored courses are available on your site for £675.00 plus vat (up to 8 attendees).

Length1 day
LevelIntermediate
FormatsIn-house · Live online · Public
Group sizeUp to 8 per group
Get a quote for your team
Level 1IntroductionLevel 2Intermediate
Overview

About the Access Intermediate course

Scheduled public courses are held at Preston, Liverpool, Manchester & London.

1 Day Access Intermediate Course | 1 delegate £225.00 plus VAT

*Book 2 or more delegates and receive significant discounts. Click here for information

  • Design a multi table relational database
  • Create parameter queries and action queries
  • Perform calculations in queries
  • Create forms and sub forms
  • Incorporate a graphic in a form
Course outline

What the day covers

4 modules · tailored to your team on in-house courses
Database Design6 topics
  • Creating a new database
  • Understanding and modifying data types
  • Setting field properties
  • Assigning the primary key
  • Creating relationships
  • Importing data
Query Design3 topics
  • Creating parameter queries
  • Calculating in queries
  • Using action queries: Make Table / Append / Delete / Update
Form Creation3 topics
  • Creating forms with subforms
  • Customising forms
  • Using the forms control toolbox
Report Design5 topics
  • Using calculations in reports
  • Grouping and sorting data
  • Creating and formatting labels
  • Modifying field properties
  • Adding a graphic to a report
Outcomes

By the end of the course, delegates will be able to

  • Design a multi table relational database
  • Create parameter queries and action queries
  • Perform calculations in queries
  • Create forms and sub forms
  • Incorporate a graphic in a form
  • Design reports with calculations
Courses & fees

Ways to book this course

In-house

Tailored Group Course

£675+ VAT
One day · up to 8 people · At your premises or live online
  • Tailored to your team
  • Trainer travel included
  • Reference materials & certificates
Request a quote
Public course

Classroom Place

£225+ VAT
One day · per delegate
  • Ideal for one or two people
  • Reference materials & certificate
  • Discounts for 2+ delegates
Request a quote
Is it right for you?

Who the course is for

Before you attend

his course is designed for delegates who have completed the Access Introduction course or have equivalent knowledge. Delegates should already be familiar with the different Access objects (tables, queries, forms and reports) and should be looking to develop their knowledge of database design and data manipulation.

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.
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