Microsoft Access Masterclass Training

Overview

Outline

Feedback

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.

Advanced Microsoft Access Training

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

Our Microsoft Access Masterclass course teaches delegates how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

If you are a looking for training specific to your business, we can provide private and in-company Microsoft Access Courses. Call us on +44 (0)1273 622272 to discuss your needs.

Prerequisites

There are no prerequisites for this course.

Course Objectives

By the end of this MS Access Masterclass training course, delegates will be able to:

Demonstrate an advanced understanding of Microsoft Access
Design advanced queries, forms and reports
Use macros to increase productivity and perform advanced functions

Who is this course for?

This course is aimed at Microsoft Access users who want to expand their knowledge to include advanced techniques and macros.

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

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

Andie Davidson - Mecmesin Ltd

Great teaching - very enjoyable & helpful.

Claire Thackway, Brighton College

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