United States Microsoft Visual Basic for Access Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Visual Basic for Access are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Visual Basic for Access freely available. Click on any of the linked lesson listings below to preview FREE!
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.
Choose your media type:
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) | |
|
Communicating 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 FeedbackTitle Information / Pricing
| Title: | Microsoft Visual Basic for Access |
| Author: | Mike Haines |
| SKU: | 33191 |
| ISBN: | 1930519214 |
| Release Date: | 2000-12-01 |
| Price: | |
| Duration: | 9 hrs / 70 lessons |
| Work Files: |
No |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
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 NOW
LEARN MORE » Select Bandwidth
Now Shipping
Client Testimonials
I joined on the 20th August 2010 to your program and I'm most impressed. I need to learn Excel for my job and at 64 years old I never thought I...
Barbara Richards