Microsoft Visual Basic for Access
Author:Mike Haines
Language:english
Category:Programming,
Lessons:0 | 0 hrs
Buy Now or get more information about Microsoft Visual Basic for Access
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.
Microsoft Visual Basic for AccessMicrosoft Visual Basic for Access: Microsoft Visual Basic for Access is actually the language that is part of Microsoft applications such as Word, Excel, and PowerPoint. In this Discovery Computer Training 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 belowListed below are all of the chapter and lesson contents for the Microsoft Visual Basic for Access Try For Free Right Now 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
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft Visual Basic for Access

Introduction

VBA Basics
VBA and the Development Environment
Event Programming pt. 1
Event Programming pt. 2
Event Programming pt. 3
Event Programming pt. 4
Event Programming pt. 5
Event Programming pt. 6
Using Events
VBA Variables
Control Structures

Modules

Intro to Modules
Creating a Module
A Sub Routine
Validate Using a Function

Communicting with the User

User Interaction
MsgBox and Input Box pt. 1
MsgBox and Input Box pt. 2
Validating Using ON_CHANGE pt. 1
Validating Using ON_CHANGE pt. 2
"Live" Calculations pt. 1
"Live" Calculations pt. 2
"Live" Calculations pt. 3
Captions and Status Bar Properties
The Registry-Writing
The Registry-Retrieving

Error Trapping and De-Bugging

Error Trapping and De-Bugging
De-Bugging
Programming the On_Error
In-Line Error Trapping

Multiple Form Applications

Multiple Form Applications
Forms Switchboard
The Forms Collection
The Dirty Property
Conditional Opening

The ActiveX-Calendar Control

The ActiveX-Calendar Control
Setting Up
Passing Data
Writing Generic Code

Looping

Looping Through Form Controls
Looping and Tags
More Looping

Programming GUI Controls

Programming GUI Controls
Combo Boxes-Intro
Combo Boxes-Using
Check Boxes

Data Access Objects

Introducing Data Access Objects
Counting Records
Using a Select Statemet
Archiving Records
Deleting Records

Unbound Forms

Unbound Forms
Front End Preparation
Object Scope
Buttons pt. 1
Buttons pt. 2
Adding a Record
Editing a Record
Deleting a Record
Cancel a Change
Moving Around

DAO Practical Applications

DAO Practical Applications
Locating Records pt. 1
Locating Records pt. 2
Locating Records pt. 3
Locating Records pt. 4
Tracking Used Records pt. 1
Tracking Used Records pt. 2
Tracking Used Records pt. 3
Tracking Used Records pt. 4

01 Introduction
0101 VBA Basics
0102 VBA and the Development Environment
0103 Event Programming pt. 1
0104 Event Programming pt. 2
0105 Event Programming pt. 3
0106 Event Programming pt. 4
0107 Event Programming pt. 5
0108 Event Programming pt. 6
0109 Using Events
0110 VBA Variables
0111 Control Structures

02 Modules
0201 Intro to Modules
0202 Creating a Module
0203 A Sub Routine
0204 Validate Using a Function

03 Communicting with the User
0301 User Interaction
0302 MsgBox and Input Box pt. 1
0303 MsgBox and Input Box pt. 2
0304 Validating Using ON_CHANGE pt. 1
0305 Validating Using ON_CHANGE pt. 2
0306 Live Calculations pt. 1
0307 Live Calculations pt. 2
0308 Live Calculations pt. 3
0309 Captions and Status Bar Properties
0310 The Registry-Writing
0311 The Registry-Retrieving

04 Error Trapping and De-Bugging
0401 Error Trapping and De-Bugging
0402 De-Bugging
0403 Programming the On_Error
0404 In-Line Error Trapping

05 Multiple Form Applications
0501 Multiple Form Applications
0502 Forms Switchboard
0503 The Forms Collection
0504 The Dirty Property
0505 Conditional Opening

06 The ActiveX-Calendar Control
0601 The ActiveX-Calendar Control
0602 Setting Up
0603 Passing Data
0604 Writing Generic Code

07 Looping
0701 Looping Through Form Controls
0702 Looping and Tags
0703 More Looping

08 Programming GUI Controls
0801 Programming GUI Controls
0802 Combo Boxes-Intro
0803 Combo Boxes-Using
0804 Check Boxes

09 Data Access Objects
0901 Introducing Data Access Objects
0902 Counting Records
0903 Using a Select Statemet
0904 Archiving Records
0905 Deleting Records

10 Unbound Forms
1001 Unbound Forms
1002 Front End Preparation
1003 Object Scope
1004 Buttons pt. 1
1005 Buttons pt. 2
1006 Adding a Record
1007 Editing a Record
1008 Deleting a Record
1009 Cancel a Change
1010 Moving Around

11 DAO Practical Applications
1101 DAO Practical Applications
1102 Locating Records pt. 1
1103 Locating Records pt. 2
1104 Locating Records pt. 3
1105 Locating Records pt. 4
1106 Tracking Used Records pt. 1
1107 Tracking Used Records pt. 2
1108 Tracking Used Records pt. 3
1109 Tracking Used Records pt. 4

Sponsors