Training Course: Microsoft Access 2003 - VBA
training course enquiry
Pre-Requisites:
Delegates should have attended the appropriate introductory and advanced courses plus have several weeks of practice. No programming experience is required.Training Course Overview/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
