Advanced Access Training

Overview

Many organizations 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.

Building upon skills covered on our beginners Access Training Course our Advanced Microsoft Access course teaches delegates how to analyze data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

Prerequisites

Before attending this course you must have attended our Beginners Microsoft Access Course or have equivalent experience.

Course Objectives

By the end of this Advanced MS Access 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

Onsite Training

This course can be run in-company anywhere & we can tailor the content to focus on your requirements.

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. We recommend that you attend our Beginners MS Access course or have equivalent experience.

Outline Details

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