Access 2007: VBA Programming
Class Outline:
Description
This course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.
Unit 1: Visual Basic Editor
Topic A: Objects
Topic B: Object Browser
Topic C: Collections
Unit 2: Programming basics
Topic A: Working with data
Topic B: Scope
Unit 3: Control structures
Topic A: Decision structures
Topic B: Loop structures
Unit 4: ActiveX Data Objects
Topic A: Getting started with ActiveX Data Objects
Topic B: Working with ActiveX Data Objects
Unit 5: VBA debugging tools
Topic A: Errors in code
Topic B: Debugging techniques
Topic C: Handling runtime errors
Appendix A: Office integration
Topic A: Automating Office 2007
Topic B: Working with Word from Access
Topic C: Working with Excel from Access