|
|
AVB201: Beginning Access VBA Training
|
Book List |
Course Links
|
|
Tuition: $195.00 per student |
Length: 1 day |
|
Synopsis:
One day beginning Access VBA course. Covers modules, classes, programming constructs, etc. Requires some familiarity with basic programming concepts.
|
Formats:
Custom scheduled corporate groups (min. 2 students) at your facility or via Remote Learning. Single individuals may arrange a private online session.
|
Scheduling:
Custom scheduled to suit your needs.
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
Session 1 | Why VBA? | 3.0 Hours | |
- 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 2 | VBA Language Constructs and Programming Techniques | 3.0 Hours | |
- 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.
|   |
Materials:
Students will receive a notebook with a printout of all slides used in their class and a training certificate.
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
Related Services |
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|