Advanced Access Training

"Great teaching - very enjoyable & helpful." - Claire Thackway, Brighton College

Many organisations have large databases in Access that have built up over the years.

Staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.

However when databases get big, making your queries and forms effective can become more complex, and it is worth investing in advanced Access training to get the most from your data and save time.

Advanced Microsoft access training builds upon skills covered on our beginners Microsoft Access Training Course.

Delegates on our advanced Microsoft access training course will learn how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

We also provide private and in-company Microsoft Access courses. Call 01273 622272 to discuss.

Advanced MS Access Feedback

"Feel I have had a rounded introduction to Access, which is exactly what I required from the course. Very friendly and patient trainer who ran the course at a flexible pace."
Paul Clarke - Hampshire Probation Trust

"Steve understood exactly what I was trying to do. the course was personalised and progressive - excellent step by step method."
Andie Davidson - Mecmesin Ltd 

Microsoft Access Course Objectives:

By the end of this Advanced MS Access training course, delegates will have extended their knowledge of Access databases to advanced levels to include using macros.

Advanced Microsoft Access Training Course Prerequisites:

Delegates on this Microsoft access course should understand the basic concepts of creating an Access Database or attended our Beginners Access training course.

Download the Advanced Microsoft Access Training Course Outline

Advanced Microsoft Access Course Content

Introduction

• Review of basic concepts:
• Design concepts
• Relationships between tables

Designing Queries

• Using And and Or statements
• Totals Queries
• Creating calculations in queries
• Parameter Queries
• Autolookup Queries

Designing Forms

• Adding controls
• Working with combo boxes
• Working with calculated controls
• Control properties
• Working with subforms

Report Design

• Creating a report using the Wizard
• Designing grouped reports
• Adding sub-totals to reports

Macros

• Creating simple macros
• Creating grouped macros
• Creating conditional macros
• Assigning macros to command buttons
• Creating a Switchboard
• Using macros to pass conditions between forms
• Using macros to pass conditions to run reports

Download the Advanced Microsoft Access Training Course Outline