|
|
|
|
|
|
AVB201: Beginning
Access VBA Training |
Book
List | Course
Links
| |
|
|
Tuition: $295.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: Corporate groups
(min. 2 students) at your facility or ours in San Juan
Capistrano, Orange County, California. Single individuals may
take a scheduled class or arrange a private class on a
different date. |
|
Scheduling: Flexible. Group and
private training can be scheduled to suit your
needs. See calendar for scheduled classes.
|
|
Group
Discounts: 2-4 students
20%, 5-8 35%, >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.
|
|
|
|
References: Please
see the book
list for references you may want to have available.
We are an Amazon.com affiliate and you may purchase your
Microsoft Access books through this site.
|
|
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
location in San Juan Capistrano, Orange County. We do,
however, offer a wide range of alternatives. Please see
FAQ's
if interested. We also travel beyond Southern
California. |
|
| |
