What past students had to say about this class:

Kate was outstanding in ensuring that the information was understood. Her patience and understanding made it a pleasure. ~J.D. \ USMC

Kate made the learning experience enjoyable-easy going atmosphere open to questions & students assisting one another; would definitely taking another class from Kate. ~C.T. \ GIA

Once again...well-taught course, can't wait for VBA-200. Thanks ~A.S. \ Callaway Golf
Course Content:

Visual Basic Editor

·         Objects

·         Object Browser

·         Collections

Programming basics

·         Data

·         Scope

Control Structures

·         Decision structures

·         Loop structures

ActiveX Data Objects

·         Getting started with ActiveX Data Objects

·         Working with ActiveX Data Objects

VBA Debugging Tools

·         Errors in code

·         Debugging techniques

·         Handling run-time errors

Office integration

·         Automating Office 2003

·         Working with Word from Access

·         Working with Excel from Access

Objectives

·         Work with objects, use Object Browser, identify collection objects, and use the Controls collection.

·         Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.

·         Use decision structures and use loop structures.

·         Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.