United States Microsoft Visual Basic for Access 2002 Tutorials
Online Contents For This Course
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!
Course 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) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | 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 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 782 courses, 81,350 video tutorials (20,800+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More