Access Programming with VBA

Overview
This two day course is designed to provide delegates with the knowledge to manipulate Access 2000/2003 and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful custom desktop solutions.


Examination information
There is no examination associated with this course.


Prerequisites
Before attending this course, students must have:
Attended appropriate introductory and advanced courses plus several weeks of practice. No programming experience is required.
Course outline

Module 1: Getting Started
Introduction to Programming in Access
Why Program in Access?
Creating a Macro
Understanding Modules
Creating a Standard Module
Understanding the Development Environment
Using the Project Explorer
Using the Properties Window
Using the Code Window


Module 2: Working with Procedures and Functions
Understanding Procedures
Creating a Sub Procedure
Creating a Function Procedure
Calling Procedures and Functions
Using the Immediate Window
Working with Code


Module 3: Understanding Objects, Properties, Methods and Events
Understanding Objects and Collections
Understanding Properties
Understanding Methods
Understanding Events


Module 4: Understanding the Access Object Hierarchy
Understanding Access Objects
Using the Object Browser
Controlling the Application Object
Understanding the Forms Collection and Form Object
Understanding the Controls Collection and Control Object
Using the With Statement
Understanding the Reports Collection and Report Object
Understanding the DoCmd Object
Using the Screen Object


Module 5: Using Variables, Arrays, and Constants
Declaring Variables
Declaring Arrays
Declaring Constants
Declaring Object Variables


Module 6: Using Functions, Message Boxes, and Input Boxes
Using Intrinsic Functions
Using Message Boxes
Using Input Boxes


Module 7: Controlling Program Execution
Using Control Structures
Working with Conditional Expressions
Using the If...Then...End If Structure
Using the If...Then...Else...End If Structure
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...Next Structure


Module 8: Debugging Code
Understanding Errors
Using Debugging Tools
Stepping Through Code and Setting Break Points
Understanding Error Events
Understanding the Err Object
Using the On Error Statement
Writing an Error Handling Routine
Compiling All Procedures