Access 2003 - VBA Programming      

Code:

 CT11-334

Series:

 Desktop Applications

Duration:

 1 day
Visual Basic Editor
Objects
Object Browser
Collections

Programming basics
Data
Scope

Control structures
Decision structures
Loop structures		 ActiveX Data Objects
Getting started with ActiveX Data Objects

VBA debugging tools
Errors in code
Debugging techniques
Handling run-time errors

Appendix A: Office integration
Automating Office 2003
Working with Word from Access
Working with Excel from Access

Access 2003 - VBA Programming


After completing this course, students will know how to:

  • 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.
  • Identify compile-time, run-time, and logical errors; use the debugging tools; and write error-handling code.

Prerequisites:


Access 2003 - Application Development or equivalent experience.