Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com

Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog

Item IDCourse Title and DescriptionLength
AVB201Beginning Access VBA Training6.0 hrs
 One day beginning Access VBA course. Covers modules, classes, programming constructs, etc. Requires some familiarity with basic programming concepts.The next class in sequence is AVB202 Intermediate Access VBA

 
Session 1Why VBA? 
 
  • Using events and event procedures in event driven programming environment.
  • Using the VBA Editor.
  • Event Types in Access.
  • Differentiating between Functions and Sub Procedures.
  • Organizing VBA code into modules.
  • Using Variables, Scope, and Data Types.
  • Exploring and using built-in functions.

 
Session 2VBA Language Constructs and Programming Techniques 
 
  • Getting interactive with Message boxes.
  • Making Decisions: If..Else.., Select Case..
  • Making Repetitions simple: Do..While, For..Next
  • Calling functions and sub procedures.
  • Using VBA editor for effective debugging.
  • Handling errors and missing data.