Access VBA Training | Chicago and Los Angeles

Fast Facts

Duration
1 day

Class Size
Max 8 students

Times
9.00am to 4.30pm

Computer
One per student

Training Manual
Included

Price
395.00

Access - VBA

Upcoming Classes
Course Outline
Instructors

Course Description

This Access VBA course is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming. Find out more about our other Microsoft Access classes.

Target Audience

Experience Access users looking to learn Access VBA. Students should already have good working knowledge of Access or have completed our Access 2003/2007 Level 3 class.

Learning Objectives

Upon successful completion of this Access VBA training course students will be able to:

VBA Terminology.
To work with Objects, their Properties, Methods, and Events.
Using Variables, Procedures and Functions in VBA.
Control Structures to Execute Code.
ActiveX Data Objects.
Work with a Recordset and Parameter query.
Learn Debugging Tools.

Upcoming Classes

Chicago	Mar, 2010	Apr, 2010	May, 2010	Jun, 2010
Access 2007 - VBA			May 20 !

Click here for directions

Los Angeles	Mar, 2010	Apr, 2010	May, 2010	Jun, 2010
Access 2007 - VBA		Apr 1		Jun 4

Click here for directions

* Class almost full ! Class guaranteed to run † Class is full

Course Outline

Visual Basic Editor

Visual Basic Terminology
Work with Objects, their properties, methods, and events
Use Object Browser to get information about Objects
Identify Collection Objects and use Collection Control

Programming Basics

Manipulate and Combine Data to get User input
Declare Variables and Procedures
Create Sub and Function Procedures
Call one Procedure from other

Control Structures

Use Decision Structures to create procedures that execute code
Use Loop structures to execute code repeatedly

ActiveX Data Objects

Examine ActiveX Data Objects architecture and collections
Connect to a Database
Work with a Recordset and Parameter query

VBA Debugging Tools

Identify compile-time, run-time and logical errors
Use the Debugging Tools
Write Error-handling code to trap errors

Meet the Instructors

Rich

Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"

CLOSE BIO

"Give Rich a raise!! He was very knowledgeable and an excellent facilitator."

Neil Alcorn - Country Financial

"I thought I'd have a difficult time with VBA, but after taking Access Levels 1,2 & 3 with Training Connection, I was prepared. Additionally, I had an excellent instructor, Rich. He moves at a good pace, but always stops if any student has a difficulty. The class format is hands-on and he always asks what we students would like to address in the day's lesson. Training Connection has prepared me well for dealing with the database on the job!"

Maria Carrasco - University of Illinois

... view bioRich