Access 2003: VBA Programming

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:

To ensure the successful completion of Access 2003: VBA Programming, we recommend completion of the following courses or equivalent knowledge (for example, familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports):

• Access 2003: Level 1
• Access 2003: Level 2
• Access 2003: Level 3

Target Audience:

Access 2003: VBA Programming is for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skill sets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2003.

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.

Outline:

• 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
  • Working with ActiveX Data Objects
• VBA debugging tools
  • Errors in code
  • Debugging techniques
  • Handling run-time errors
• Appendix: Office integration
  • Automating Office 2003
  • Working with Word from Access
  • Working with Excel from Access

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.