Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.

HANDS-ON

Advanced Microsoft Access

(2.4 ceu)

An elective in the Professional Sequence in Database Management

This course introduces VBA syntax, the programming interface (VB Editor), the event-driven programming model in MS Access, and data access technologies (DAO/ADO).

On successful completion you should be able to:

navigate comfortably in the VBA environment
create basic programming units (sub- and function routines)
apply basic VBA programming elements such as variables (declaring, scope, lifetime) and controlling executions (If-Else-End If, Do/While/Until loops, Select Case)
implement dynamic coding using the MS Access object model and hierarchy
identify and use form, report, and control events to link program units to your application
bulletproof your application using sophisticated error handling routines
use data access technologies (DAO/ADO) to automate database tasks and denormalize data structures

Prerequisite: Successful completion of Intermediate Microsoft Access or equivalent. Previous programming experience is helpful but not required.

Sign up for all three courses now (Beginning, Intermediate, and Advanced Microsoft Access) and get a $200 discount on your final course.

There are currently no sections open for enrollment.

Sections closed for enrollment

Sat. April 19, San Francisco