VBA For Access Training

Overview

Outline

Feedback

This VBA for Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.

Prerequisites

This course is for those who possess and advanced understanding of Microsoft Access and are looking to expand their knowledge even further. Ideally, the delegate will have some knowledge of macros in relation to Office applications.

Course Objectives

After attending this VBA for Access course, delegates will be able to:

Use VBA for Access for advanced automation features
Write and understand Visual Basic code
Use VBA to manipulate and edit a database

Who is this course for?

Where Code is stored

Standard modules
Class modules

Development Environment

Adding Code to a Form or Report
Types of Procedures
Entering Code

Running Code

Run mode and Design mode
Running Code from the development environment
Running Code from the host application

Reusing Code

Exporting a file
Importing a file

Using VB for Applications Using Variables

Lifetime and scope of variables
Using and writing sub-procedures
Using and writing Function procedure

Controlling Programme flow

Conditional structures
Looping structures
Trapping errors

Debugging

Using the break mode
Using the VB Editor debug features

Using Standard VB

Input Boxes
Message Boxes
Standard VB Functions
Functions in your Code

Access Object Module Forms and Form Events

Reports and Report Events
Creating a Workspace Using the Microsoft Jet Engine
Retrieving a Recordset
Navigating Records
Updating Records
Adding Records
Querying Data

Using VB

Using VB Objects, Methods and Properties to manipulate, read, edit and update data in a Database

Just a quick line to let you know how much Ilesh and myself gained from the excellent VBA course we recently attended at your offices. Your facilities are excellent and we were most impressed by the trainer's depth of knowledge and ability to restructure the course dynamically to ensure that we obtained the most relevant training. The two days were not only very informative but also good fun!

Alan Hill - GlaxoSmithKline

VBA For Access Training

Sorry! Our team is updating this schedule!