Microsoft Visual Basic for Access Tutorial Video

Introduction
Welcome/Intro Demo
Course Overview Demo
Who This Course Is For Demo

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

Variables
Variables Explained Demo
Creating Variables Demo
Data Types Demo
Expressions Demo
Constants Demo
Static Variables Demo
Option Explicit Demo
Variable Scope Demo
Option Compare Demo

If you purchase the CD all the contents listed below are also included.

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

Event Based Programming
Events
Handling Events
Choosing Events
Form Events
Control Events
DoCmd

Forms
Collections
Forms Collection
Multiple Forms

Validating Data
Validation Levels
Database Validation
Code Level Validation
Validating Strings
Validating Numbers
Validating Dates

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

Control Structures
If/Then
Immediate If
Case Statements
Choose Function

Looping Through Code
Looping Structures
For Next Loops
For Each
Do Loops
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
Intro to Debugging
Navigating Your Code
Breakpoints
Working In Break Mode
Immediate Window
Locals Window
Watch Window

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

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

Credits
About The Author