Title Language  : 

Find a Course... Try for Free!

 

Microsoft Visual Basic for Access 2002 Tutorials

Course Content
Microsoft Visual Basic for Access 2002 is actually the language used to build Microsoft applications such as Word, Excel, and PowerPoint. In this Virtual Training Company tutorial, author Mark Long teaches you how to use Visual Basic for Access to build and publish your own programs. He teaches you the concept of event programming, code control structures, variables, constants, and much more. To get started today, simply click on one of the Visual Basic for Access 2002 lessons.
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
Welcome/Intro (03:15)
Course Overview (04:18)
Who This Course Is For (03:00)
VBA Basics
This is VBA (03:08)
VBA IDE (03:22)
Project Window (05:17)
Properties Window (05:56)
Custom Toolbar (03:04)
Writing Code (06:33)
Getting Assistance In VBA (03:05)
Variables
Variables Explained (03:15)
Creating Variables (03:53)
Data Types (03:55)
Expressions (03:17)
Constants (03:43)
Static Variables (02:43)
Option Explicit (04:33)
Variable Scope (04:16)
Option Compare (02:08)
Modules
Intro to Modules (02:48)
Procedures (03:55)
Using Arguments (02:42)
Public vs Private (03:32)
Functions (02:14)
Using Form Modules (02:14)
Using Standard Modules (02:59)
Enhancing Code Readability (02:39)
Event Based Programming
Events (02:17)
Handling Events (02:08)
Choosing Events (03:41)
Form Events (03:43)
Control Events (04:27)
DoCmd (02:32)
Forms
Collections (02:30)
Forms Collection (04:29)
Multiple Forms (03:27)
Validating Data
Validation Levels (03:23)
Database Validation (05:09)
Code Level Validation (03:04)
Validating Strings (03:08)
Validating Numbers (03:43)
Validating Dates (01:49)
Object Oriented Programming
Intro to OOP (03:27)
Classes (02:20)
Objects (02:56)
Creating A Class (02:25)
Creating An Object (04:21)
Object Browser (04:19)
Using Application Objects (03:10)
Control Structures
If/Then (04:38)
Immediate If (02:02)
Case Statements (03:15)
Choose Function (02:56)
Looping Through Code
Looping Structures (01:56)
For Next Loops (04:07)
For Each (02:54)
Do Loops (02:31)
Do While (02:09)
Do Until (01:58)
Do Loop While (01:43)
Do Loop Until (01:56)
Handling Errors
Types of Errors (03:40)
Error Handling Terminology (03:09)
Creating An Error Handler (03:57)
Using The Err Object (03:55)
Exiting Error Handler Routine (03:41)
Error Handling Templates (02:39)
Debugging
Intro to Debugging (01:51)
Navigating Your Code (03:50)
Breakpoints (04:17)
Working In Break Mode (02:48)
Immediate Window (03:29)
Locals Window (01:42)
Watch Window (01:41)
Data Access
Data Access Basics (03:40)
Connection Object (05:26)
Recordset Object (04:59)
Referencing Fields (03:57)
Navigating Records (04:26)
SQL Queries (03:25)
Updating Records (03:48)
Adding Records Pt.1 (06:03)
Adding Records Pt.2 (03:29)
Deleting Records Pt.1 (03:43)
Deleting Records Pt.2 (04:54)
Connecting To SQL Server (03:48)
DAO vs ADO (02:22)
Application Completion
Documentation (01:53)
Testing (03:50)
Startup Options (01:43)
Splash Screens (03:02)
Packaging For Delivery (03:05)
Using The Database Splitter (02:06)
Credits
About The Author (01:47)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Visual Basic for Access 2002
Author: Mark Long
SKU: 33548
ISBN: 1-932808-20-5
Duration: 7 hrs / 94 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