Access Intermediate

Course summary
1 day
Corporate Training for Teams
STL courses

Access Intermediate

Courses never cancelled. 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 Advanced training course.

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 from £480. Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

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

  Contact the provider

  Get more information

  Register your interest

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.

Contact information for STL


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

 Show phone number

Similar Courses

Request information

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

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

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

Find more courses here