[Home]  --> [Advanced MS Access Home]  -->[You are here: Advanced MS Access Class Syllabus]

1. Class, 8:30am - 11:30am	2. Class, 12:30pm - 3:30pm
Overview of Programming in MS Access Events and Modules Visual Basic for Applications (VBA) Subroutine/Functions	Basic VBA Language Elements Controlling Executions If..Then..Else...End If, Select Case Loop Structures Variables: Declaring, Scope and Lifetime Data Types of Variables
3. Class, 8:30am - 11:30am	4. Class, 12:30pm - 3:30pm
Objects, Collections, Properties, and Methods Working with Objects Objects and Collections Refering to Objects and Collections Properties and Methods of Objects and Collections	Events in MS Access Overview of Events Sequence of Events Events in an Application Record and Control Buffers Before and After Update Event
5. Class, 8:30am - 11:30am	6. Class, 12:30pm - 3:30pm
Error Handling Errors in MS Access What are Errors? Compile-time, Run-time, and Logic Errors Handling Errors in VBA Getting Information about Errors Debugging Tools	Data Access Methods, DAO and ADO Introduction to Data Access Objects (DAO, ADO) DAO Object Hierarchy, ADO Object Hierarchy Programming with DAO, ADO Creating Recordset Objects Looping through Recordsets
7. Class, 8:30am - 11:30am	8. Class, 12:30pm - 3:30pm
VBA Code Examples, Part I Transaction Processing, Commit, Rollback Using the NotInList event to add data to a table Running a Word Mail Merge from within Access for reporting purposes Programmatically refreshing linked tables	VBA Code Examples, Part II Controlled Close of a Form Multi-Select List Box Customized Query Form