Title Language  : 

Find a Course... Try for Free!

 

Microsoft Visual Basic for Access Tutorials

Course Content
Microsoft Visual Basic for Access is actually the language that is part of Microsoft applications such as Word, Excel, and PowerPoint. In this Virtual Training Company tutorial, author Mike Haines explains VBA in the context of Access. He teaches you the concept of event programming, code control structures, variables and constants, and much more. Start becoming familiar with VBA now by clicking one of the links below.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
Introduction
VBA Basics (00:47)
VBA and the Development Environment (12:04)
Event Programming pt. 1 (02:41)
Event Programming pt. 2 (01:49)
Event Programming pt. 3 (01:26)
Event Programming pt. 4 (02:10)
Event Programming pt. 5 (01:42)
Event Programming pt. 6 (01:45)
Using Events (07:55)
VBA Variables (15:31)
Control Structures (10:52)
Modules
Intro to Modules (00:32)
Creating a Module (07:40)
A Sub Routine (07:21)
Validate Using a Function (10:46)
Communicting with the User
User Interaction (01:31)
MsgBox and Input Box pt. 1 (03:50)
MsgBox and Input Box pt. 2 (01:37)
Validating Using ON_CHANGE pt. 1 (03:05)
Validating Using ON_CHANGE pt. 2 (03:21)
"Live" Calculations pt. 1 (01:56)
"Live" Calculations pt. 2 (01:55)
"Live" Calculations pt. 3 (03:11)
Captions and Status Bar Properties (16:00)
The Registry-Writing (09:09)
The Registry-Retrieving (07:26)
Error Trapping and De-Bugging
Error Trapping and De-Bugging (01:26)
De-Bugging (10:01)
Programming the On_Error (09:47)
In-Line Error Trapping (16:42)
Multiple Form Applications
Multiple Form Applications (01:11)
Forms Switchboard (14:34)
The Forms Collection (09:19)
The Dirty Property (08:31)
Conditional Opening (08:45)
The ActiveX-Calendar Control
The ActiveX-Calendar Control (01:02)
Setting Up (07:40)
Passing Data (11:14)
Writing Generic Code (08:55)
Looping
Looping Through Form Controls (00:46)
Looping and Tags (11:26)
More Looping (04:48)
Programming GUI Controls
Programming GUI Controls (00:25)
Combo Boxes-Intro (04:22)
Combo Boxes-Using (08:28)
Check Boxes (12:42)
Data Access Objects
Introducing Data Access Objects (01:32)
Counting Records (08:32)
Using a Select Statemet (05:23)
Archiving Records (09:42)
Deleting Records (02:03)
Unbound Forms
Unbound Forms (02:23)
Front End Preparation (09:08)
Object Scope (08:08)
Buttons pt. 1 (07:27)
Buttons pt. 2 (08:19)
Adding a Record (14:37)
Editing a Record (08:28)
Deleting a Record (07:10)
Cancel a Change (02:56)
Moving Around (16:26)
DAO Practical Applications
DAO Practical Applications (01:37)
Locating Records pt. 1 (09:10)
Locating Records pt. 2 (06:32)
Locating Records pt. 3 (10:08)
Locating Records pt. 4 (08:21)
Tracking Used Records pt. 1 (14:03)
Tracking Used Records pt. 2 (03:22)
Tracking Used Records pt. 3 (12:32)
Tracking Used Records pt. 4 (07:58)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Visual Basic for Access
Author: Mike Haines
SKU: 33191
ISBN: 1930519214
Duration: 9 hrs / 70 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products