Access 2003: VBA Programming
Class Outline:
Description:
This course on Access 2003 VBA Programming is designed for experienced Access users who want to learn activex data objects, control structures, and the basics of VBA programming.
Prerequisites:
Access 2003: Application Development or equivalent experience
Table of Contents:
Unit 1: Visual Basic Editor
Topic A: Objects
Topic B: Object Browser
Topic C: Collections
Unit 2: Programming basics
Topic A: 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 run-time errors
Appendix A: Office integration
Topic A: Automating Office 2003
Topic B: Working with Word from Access
Topic C: Working with Excel from Access
Objectives:
-Work with objects, use Object Browser, identify collection objects, and use the Controls collection.
-Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.
-Use decision structures and use loop structures.
-Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.