Visual Basic for Access 2002

Introduction
Tutorials Intro
Course Overview
Who This Course Is For

Microsoft VBA Basics
This is VBA
VBA IDE
Project Window
Properties Window
Custom Toolbar
Writing Code
Getting Assistance In VBA

Variables in VB for Access
Variables Explained
Creating Variables
VBA Data Types
Expressions
Constants
Static Variables in Visual Basic for Access
Option Explicit
Variable Scope
Option Compare

VBA Modules
Intro to VBA Modules
Procedures
Using Arguments in VBA
Public vs Private
VBA Functions
Using Form Modules
Using Standard Modules
Enhancing Code Readability

Event Based Programming in VBA
Visual Basic for Access Events
Handling Events
Choosing Events
Form Events
Control Events
DoCmd Tutorials

Forms
Collections
Forms Collection
Multiple Forms

Validating Data using VB for Access
VBA Validation Levels
Database Validation
Code Level Validation
Validating Strings in Visual Basic for Access
Validating Numbers
Validating Dates

Object Oriented Programming
Intro to OOP
Classes Tutorials
Objects
Creating A Class
Creating An Object
Object Browser
Using Application Objects

VBA Control Structures
If/Then
Immediate If
Visual Basic for Access Case Statements
Choose Function

Looping Through Code
Visual Basic for Access Looping Structures
For Next Loops
For Each
Do Loops Tutorials
Do While
Do Until
Do Loop While
Do Loop Until

Handling Errors
Types of Errors
Error Handling Terminology
Creating An Error Handler
Using The Err Object
Exiting Error Handler Routine
Error Handling Templates

Debugging VBA
Intro to Debugging
Navigating Your Code
Visual Basic for Access Breakpoints
Working In Break Mode
Immediate Window
Locals Window Tutorials
Watch Window

VBA for Data Access
Data Access Basics
Connection Object
Recordset Object
Referencing Fields
Navigating Records
SQL Queries
Updating Records
Adding Records Tutorials 1
Adding Records Pt.2
Deleting Records Pt.1
Deleting Records Pt.2
Connecting To SQL Server
DAO vs ADO

Application Completion
Documentation
VBA Testing
Startup Options
Splash Screens
Packaging For Delivery
Using The Database Splitter Tutorials

Credits
About The Author