Microsoft Visual Basic for Access Tutorial Try for FREE

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Visual Basic for Access training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

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

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