Username: 
Password: 
Microsoft Visual Basic for Access 2002 Tutorials

Online Contents For This Title

We have made some of the video tutorials for Microsoft Visual Basic for Access 2002 freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
   Title Description
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.

Choose your media type:

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)

This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.


Tutorial Information

Title: Microsoft Visual Basic for Access 2002
Author: Mark Long
SKU: 33548
ISBN: 1-932808-20-5
Release Date: 2004-10-14
Duration: 7 hrs / 94 lessons
Work Files: Yes
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

Subscription / Purchase Information

This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.


Also Available in CD format

Single User: US$ 99.95      Purchase/Add to Cart

Select Bandwidth