Become a member

Online Access to 1000+ Courses!

Microsoft Visual Basic for Access Course

Author : Mike Haines

9hrs (70 Lessons) 2000-12-01

About the course
Details

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Transcription not available

Course: Microsoft Visual Basic for Access
Author: Mike Haines
SKU: 33191
ISBN: 1930519214
Work Files: No
Captions: No
Subject: Programming
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

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)