Home » Training Courses » Microsoft Office Training » Advanced Microsoft Access Training

Advanced Microsoft Access Training

1 day - £215 + vat

Advanced Access Training 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.

Microsoft Access Course Objectives:

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

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