Access VBA Training

1. Access 2003 VBA - $395 (1 day - instructor-led)

This course is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming.

• VBA terminology
• To work with Objects, their properties, methods, and events
• Using Variables, Procedures and Functions in VBA
• Control Structures to execute code
• ActiveX Data Objects
• Work with a Recordset and Parameter query
• Learn Debugging Tools

• Visual Basic Terminology
• Work with Objects, their properties, methods, and events
• Use Object Browser to get information about Objects
• Identify Collection Objects and use Collection Ccontrol

• Manipulate and Combine Data to get User input
• Declare Variables and Procedures
• Create Sub and Function Procedures
• Call one Procedure from other

• Use Decision Structures to create procedures that execute code
• Use Loop structures to execute code repeatedly

• Examine ActiveX Data Objects architecture and collections
• Connect to a Database
• Work with a Recordset and Parameter query

• Identify compile-time, run-time and logical errors
• Use the Debugging Tools
• Write Error-handling code to trap errors