United States
Microsoft Visual Basic for Access Tutorials
Online Contents For This Course
We have made some of the video tutorials for Microsoft Visual Basic for Access freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
|
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 FeedbackCourse Information
| Course: | Microsoft Visual Basic for Access |
| Author: | Mike Haines |
| SKU: | 33191 |
| ISBN: | 1930519214 |
| Release Date: | 2000-12-01 |
| Duration: | 9 hrs / 70 tutorials |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 715 courses, 81,350 video tutorials (14,200+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More