Microsoft Access 2003 VBA
Duration
2 days
Prerequisites
Delegates should have attended the appropriate introductory and advanced courses plus have several weeks of practice. No programming experience is required.This course is available on our new V-Learning platform or as an onsite/closed event. Please call for details.
Course Content
Module 1
• Getting Started
• Introduction to Programming in Access
• Why Program in Access?
• Understanding the Development Environment
• Using Visual Basic Help
Module 2
• Working with Procedures and Functions
• Understanding Modules
• Creating a Standard Module
• Understanding Procedures
• Creating a Sub Procedure
• Calling Procedures
• Using the Immediate Window to Call Procedures
• Creating a Function Procedure
• Naming Procedures
• Organizing Code and Procedures
• Working with the Code Editor
Module 3
• Understanding Objects
• Understanding Classes and Objects
• Navigating the Access Object Hierarchy
• Understanding Collections
• Using the Object Browser
• Working with the Application Object
• Understanding the Form Object
• Working with Properties
• Using the With Statement
• Working with Methods
• Understanding the DoCmd Object
• Working with Events
• Understanding the Order of Events
Module 4
• Using Expressions, Variables, and Intrinsic Functions
• Understanding Expressions and Statements
• Declaring Variables
• Understanding Data Types
• Working with Variable Scope
• Working with Variable Lifetime
• Considering Variable Scope and Lifetime Together
• Using Intrinsic Functions
• Understanding Constants
• Using Intrinsic Constants
• Using Message Boxes
• Using Input Boxes
Module 5
• Controlling Program Execution
• Understanding Control-of-Flow Structures
• Working with Boolean Expressions
• Using the If...End If Decision Structures
• Using the Select Case...End Select Structure
• Using the For...Next Structure
• Using the For Each...Next Structure
• Using the Do...Loop Structure
• Guidelines for use of Branching Structures
Module 6
• Working with Recordsets
• Declaring and Creating Object Variables
• Working with the ADODB Recordset Object
• Specifying a Recordset Cursor Type
• Locking Records for Updating
• Specifying a Recordset Cursor Location - Optional
• Using the CacheSize Property - Optional
• Understanding Recordset Cursor Properties - Optional
Module 7
• Debugging Code
• Understanding Errors
• Using Debugging Tools
• Setting Breakpoints
• Setting Break Expressions
• Using Break Mode during Run Mode
• Stepping through Code
• Determining the Value of Expressions
Module 8
• Handling Errors
• Understanding Error Handling
• Understanding VBA's Error Trapping Options
• Trapping Errors with the On Error Statement
• Understanding the Err Object
• Writing an Error-Handling Routine
· Working with Inline Error Handling