United States
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.
View All Titles 
Email this Page
Send us FeedbackTutorial 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.
Purchase/Add to CartSelect Bandwidth
Now Shipping
Client Testimonials
Thanks VTC! I've learned more stuff in here and much faster than if I had bought a book or slept through a class. Keep up the good work and keep on...
Arellano Torres