Corporate Training for Teams
4.8 (69 Reviews)

Access Intermediate

STL, Nationwide
1 day
1 day
Leave your details so the provider can get in touch

Access Intermediate

STL courses

  • This course is designed for those users who wish to step their current knowledge of Access to take advantage of the more complex features. On completion delegates will understand relational databases and be able to work with related tables. They will learn how to generate much more complicated queries and create more advanced forms and reports before tackling PivotCharts and PivotTables.

    After completing this course you will be prepared to attend the Access Advanced training course.

What to expect

  • 24 months post training support included .
  • Tailored and bespoke programme options .
  • Our experienced training and logistics team in the last 23 years have assisted 203,891 people .
  • Over 14,047 organisations trained .
  • We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
  • Delivery UK wide and international (75+ countries delivered) .

Suitability - Who should attend?

Our Microsoft Access Intermediate course is suitable for those with a basic working knowledge of Microsoft Access.

Training Course Content

What's new in Access

Creating relational databases

Database normalising
Introducing relating tables
Adding referential integrity

Working with related tables

The lookup wizard
Changing lookup fields
Inputting data to related tables

Defining data entry rules

Using input masks
Setting a property
Setting a validation rule

Using advanced query features

How to join a table in queries
Creating a calculated field
Using an action query

Creating advanced queries

Summarise and group values
Create a crosstab query
Using a parameter query

Creating advanced form design

Working with graphics
Working with calculations
Working with combo boxes
Working with unbound controls

Using advanced report features

Create customized headers and footers
Add a calculated value
Work with sub-reports


Prices on application. Contact us for quote.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Access Intermediate.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.8

Based on 69 reviews.
Write a review!
29 Jun 2023

Everything came together from Tuesday and was a lot less overwhelming due to knowledge picked up in previous training

02 Mar 2023

Most useful topic: all of it

27 Apr 2022

Most useful topic: learning about turning data into tables

1 Northey Street, 2nd Floor, CA House
E14 8BT London


Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider