Access Intermediate

Course summary
Length: 1 day
Price: 199 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 18/01/2018 09:30 - London
Course Dates
18/01/2018 09:30  (English)
199 GBP
19/04/2018 09:30  (English)
199 GBP
04/06/2018 09:30  (English)
199 GBP
19/07/2018 09:30  (English)
199 GBP
31/08/2018 09:30  (English)
199 GBP
18/10/2018 09:30  (English)
199 GBP

Access Intermediate

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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 2013 Advanced training course.

Suitability - Who should attend?

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

Training Course Content

What's new in Access 2013

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


List price £330 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....

Read more and show all courses with Provider: STL

Request information - obligation free

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

  Contact the provider

  Get more information

  Register your interest


Contact information for STL


Greater London
2nd Floor, Cruising Association House, 1 Northey Street
E14 8BT Limehouse Basin

 Show phone number

Reviews by course attendees

Tessa Rowland; Technical Manager   |   08/06/2016
Most useful topic: Unions and multitab forms
Katy Triggs; Administrative Assistant   |   08/06/2016

Most useful topic: Creating forms
Enter & win £50 voucher


Take our survey and go in the draw to win a £50 Amazon Voucher

Take the survey

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Access Intermediate course - simply fill out your details:

Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

Find more courses here