Fabian Associates IT Training

Tel: 020 8566 6310

E-mail: info@fabmark.co.uk

Fabian Associates IT Training
                and Project Management Training
Home    |    Courses    |    Prices    |    Booking    |    About Us    |    Links
.NET Training

Java Training

PHP Training

Database Training

Project Management

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


Anyone with moderately sophisticated database needs


Essential: Have taken the Introduction to Access course or have knowledge of database concepts and usage (simple design; creating, querying and updating tables; simple form and report creation and usage)


2 days


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

Site Map | Copyright