United States Microsoft Visual Basic for Access 2002 Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Visual Basic for Access 2002 are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Visual Basic for Access 2002 freely available. Click on any of the linked lesson listings below to preview FREE!
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:
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 FeedbackTitle Information / Pricing
| Title: | Microsoft Visual Basic for Access 2002 |
| Author: | Mark Long |
| SKU: | 33548 |
| ISBN: | 1-932808-20-5 |
| Release Date: | 2004-10-14 |
| Price: | |
| Duration: | 7 hrs / 94 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
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 NOW
LEARN MORE » Select Bandwidth
Now Shipping
Client Testimonials
I was impressed with your presentation of stats and was an outstanding way for me to brush-up on my Stats background. I have been a SAS programmer...
Miriam Rosenblatt