Access VBA
Two Day Course

Course Overview

This hands-on course is designed to teach the delegate how to develop Access to meet the changes that are required in systems development.  This is achieved by combining the Visual Basic with Microsoft Access.  Delegates can therefore build a greater functionality into their customised applications

Delegates Requirements

A good working knowledge of Windows, the Microsoft  Access interface, table creation, basic query and report writing functions, macro development and relational database concepts gained from prior attendance on an Access Advanced Course and consolidation of knowledge through practical experience is essential.

Who Should Attend

New  Access  programmers who want to learn the features of VBA programming language.

Course Outline

The VBA Programming Environment

When to Use VBA Instead of Macros

VBA's Development Environment

The Programming Environment

The Object Browser

Creating Procedures

Programming in the VBA Language

Coding in Visual Basic for Applications

Using Variables and Expressions

Branching and Looping Commands

Indenting Code

Branching Commands

Using Arrays and Collections

Typing in Code

Optional and Named Arguments

Passing Arrays as Arguments

Code Compilation Finding Bugs

Types of Error

Debugging Code

Error Handling in VBA

Ignoring Errors

Trapping Errors

Writing Useful Error Handlers

Logging Errors

Manipulating Data with DAO and SQL

Data Access Objects (DAO); DAO Hierarchy

Working with Objects and Collections

Opening Databases Programmatically

Database and Recordset Objects

Dynasets; Snapshots

Manipulating Data with VBA Methods

Finding Records in a Recordset

Editing Data in a Recordset

Transaction Processing Commands

Using Recordsets to Manipulate Imported Data

Creating, Using, and Deleting Queries from VBA

Changing Database Definitions through VBA

Using SQL to Manipulate Databases

SQL Data Modification Statements

Methods of Running SQL from VBA Code

Class Modules and Form-Event Procedures

Class Modules

Using a Class's Properties an d Methods

The PDM Example: Time Managing Multiple

Projects

Using Form Events

Access  Form Events and Properties

Code Behind Forms; Changing Form Properties

Soft Validation; Creating Validation Event Procedures 

Value Derivation; Creating New Form Instances

Tying Forms/Reports Together

Using Form Class Modules  

TO BOOK A COURSE
Telephone 01794 521449