Microsoft Visual Basic for Access 2002 is actually the language used to build Microsoft applications such as Word, Excel, and PowerPoint. In this Virtual Training Company tutorial, author Mark Long teaches you how to use Visual Basic for Access to build and publish your own programs. He teaches you the concept of event programming, code control structures, variables, constants, and much more. To get started today, simply click on one of the Visual Basic for Access 2002 lessons.
IntroductionWelcome/IntroCourse OverviewWho This Course Is ForVBA BasicsThis is VBAVBA IDEProject WindowProperties WindowCustom ToolbarWriting CodeGetting Assistance In VBAVariablesVariables ExplainedCreating VariablesData TypesExpressionsConstantsStatic VariablesOption ExplicitVariable ScopeOption CompareModulesIntro to Modules
Procedures
Using Arguments
Public vs Private
Functions
Using Form Modules
Using Standard Modules
Enhancing Code Readability
Event Based ProgrammingEvents
Handling Events
Choosing Events
Form Events
Control Events
DoCmd
FormsCollections
Forms Collection
Multiple Forms
Validating DataValidation Levels
Database Validation
Code Level Validation
Validating Strings
Validating Numbers
Validating Dates
Object Oriented ProgrammingIntro to OOP
Classes
Objects
Creating A Class
Creating An Object
Object Browser
Using Application Objects
Control StructuresIf/Then
Immediate If
Case Statements
Choose Function
Looping Through CodeLooping Structures
For Next Loops
For Each
Do Loops
Do While
Do Until
Do Loop While
Do Loop Until
Handling ErrorsTypes of Errors
Error Handling Terminology
Creating An Error Handler
Using The Err Object
Exiting Error Handler Routine
Error Handling Templates
DebuggingIntro to Debugging
Navigating Your Code
Breakpoints
Working In Break Mode
Immediate Window
Locals Window
Watch Window
Data AccessData 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 CompletionDocumentation
Testing
Startup Options
Splash Screens
Packaging For Delivery
Using The Database Splitter
CreditsAbout The Author
Click here to find out more about the Microsoft Visual Basic for Access 2002 Training CD 
