Advanced Microsoft Access

Course Overview

Having completed our Introductory Microsoft Access training course, you will now be armed with the basics. At this point, you will probably either find that your data needs are outstripping your expertise or that you are beginning to appreciate the benefits that could be reaped from more sophisticated database applications. Either way, this course is for you. It will allow you to integrate your data more successfully, handle it in a more sophisticated way and automate many of your day-to-day tasks.

This course is also suitable for anybody who has taken any other form of introductory Microsoft Access training.

What You Will Learn

• Advanced Design Techniques
• Advanced Querying
• Advanced Forms and Reports
• Creating Menus
• Database Security
• Macros and an Introduction to VBA

Audience

Anyone with moderately sophisticated database needs

Requirements

Duration

2 days

Structure

Learning Unit 1; Review of the Basic Concepts

1.1 Design Basics

1.2 Creating a database

1.3 Querying and editing your database

1.4 Forms and Reports

Learning Unit 2; Advanced Design

2.1 Grouping and totalling

2.2 Joins

2.3 Functions

2.4 Parameter queries

2.5 Action queries

2.5 CrossTab queries

2.5 SQL queries

2.6 Access and XML

Learning Unit 3; Advanced Forms and Reports

3.1 Customising Sub Forms

3.2 Combo Boxes

3.3 Option Boxes

3.4 Command Buttons

3.5 Form Properties

3.6 Dialog Boxes

3.7 Creating an Opening Screen

3.8 Customising Sub Reports

3.9 Report Properties

3.10 Adding sections and using functions in your reports

Learning Unit 4; Macros and Introduction to VBA

4.1 Creating and Running Macros

4.2 Autokey Macros

4.3 The Autoexec Macro

4.4 Conditions within Macros

4.5 Macro Groups

4.5 Introduction to VBA

Learning Unit 5; Creating a Menu System

5.1 Switchboard Manager

5.2 Forms and Macros

Learning Unit 6; System Management and Security

6.1 Introduction to Security

6.2 Managing your Database

Back to Top