This course introduces Visual Basic for Applications (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 will be able to apply these new skills:
- Navigate comfortably in the VBA environment (VB Editor).
- 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.
Prerequisites: Successful completion of Intermediate Microsoft Access, or a strong background in MS Access using all
main objects except modules. Previous programming experience is helpful but not required.
Class Syllabus
In-class Practice Problems
Homework Assignments
Database Solution Files
Download Class Database Files: Access 2000 Access 97