Become a member

Online Access to 1000+ Courses!

Microsoft Visual Basic for Access 2002 Course

Author : Mark Long

7hrs (94 Lessons) 2004-10-14

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Transcription not available

Course: Microsoft Visual Basic for Access 2002
Author: Mark Long
SKU: 33548
ISBN: 1-932808-20-5
Work Files: Yes
Captions: No
Subject: Programming
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

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)