Microsoft Access Visual Basic Programming

Two Day Course

Course Outline

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

Delegates Requirement

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 practical experience or by prior attendance on an Access Advanced  Course is essential.

Who Should Attend

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

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

Access Introduction

Access Intermediate

Access Advanced

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

MRSK Business Training, Lone Barn Farm, Stanbridge Earls, Romsey Hampshire, SO51 0HE.