Professional Training
4.5 (1405 Reviews)

Access Intermediate

STL, In London (+21 locations)
Length
1 day
Price
330 GBP excl. VAT
Next course start
29 July, 2024 (+51 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
330 GBP excl. VAT
Next course start
29 July, 2024 (+51 start dates)
Course delivery
Classroom, Virtual Classroom
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

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • Face-to-Face and Virtual Instructor led .
  • And more... .

Upcoming start dates

Choose between 51 start dates

29 July, 2024

  • Classroom
  • London
  • English

9 August, 2024

  • Virtual Classroom
  • Online
  • English

28 August, 2024

  • Classroom
  • London
  • English

6 September, 2024

  • Virtual Classroom
  • Online
  • English

27 September, 2024

  • Classroom
  • London
  • English

7 October, 2024

  • Virtual Classroom
  • Online
  • English

28 October, 2024

  • Classroom
  • London
  • English

5 November, 2024

  • Virtual Classroom
  • Online
  • English

27 November, 2024

  • Classroom
  • London
  • English

5 December, 2024

  • Virtual Classroom
  • Online
  • English

24 December, 2024

  • Classroom
  • London
  • English

7 January, 2025

  • Virtual Classroom
  • Online
  • English

23 January, 2025

  • Classroom
  • London
  • English

6 February, 2025

  • Virtual Classroom
  • Online
  • English

21 February, 2025

  • Classroom
  • London
  • English

6 March, 2025

  • Virtual Classroom
  • Online
  • English

24 March, 2025

  • Classroom
  • London
  • English

3 April, 2025

  • Virtual Classroom
  • Online
  • English

23 April, 2025

  • Classroom
  • London
  • English

1 May, 2025

  • Virtual Classroom
  • Online
  • English

23 May, 2025

  • Classroom
  • London
  • English

30 May, 2025

  • Virtual Classroom
  • Online
  • English

23 June, 2025

  • Classroom
  • London
  • English

30 June, 2025

  • Virtual Classroom
  • Online
  • English

23 July, 2025

  • Classroom
  • London
  • English

30 July, 2025

  • Virtual Classroom
  • Online
  • English

21 August, 2025

  • Classroom
  • London
  • English

28 August, 2025

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

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

Expenses



List price £330, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

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

customer-outreach-badge-2019

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

Based on 1405 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
Tessa Rowland; Technical Manager
08 Jun 2016
Access Intermediate

Most useful topic: Unions and multitab forms

5/5
Katy Triggs; Administrative Assistant
08 Jun 2016
Access Intermediate
5/5
Glenn Burke; FINANCE AND OPERATIONS ADMINISTRATOR
22 Apr 2016
Access Intermediate

Most useful topic: Creating forms

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

STL

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

Ads