Microsoft Visual Basic for Access 2002

Training Provided by The Virtual Training Company 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.

Microsoft Visual Basic for Access 2002

Introduction

1. Welcome/Intro
2. Course Overview
3. Who This Course Is For

VBA Basics

1. This is VBA
2. VBA IDE
3. Project Window
4. Properties Window
5. Custom Toolbar
6. Writing Code
7. Getting Assistance In VBA

Variables

1. Variables Explained
2. Creating Variables
3. Data Types
4. Expressions
5. Constants
6. Static Variables
7. Option Explicit
8. Variable Scope
9. Option Compare

Modules

1. Intro to Modules
2. Procedures
3. Using Arguments
4. Public vs Private
5. Functions
6. Using Form Modules
7. Using Standard Modules
8. Enhancing Code Readability

Event Based Programming

1. Events
2. Handling Events
3. Choosing Events
4. Form Events
5. Control Events
6. DoCmd

Forms

1. Collections
2. Forms Collection
3. Multiple Forms

Validating Data

1. Validation Levels
2. Database Validation
3. Code Level Validation
4. Validating Strings
5. Validating Numbers
6. Validating Dates

Object Oriented Programming

1. Intro to OOP
2. Classes
3. Objects
4. Creating A Class
5. Creating An Object
6. Object Browser
7. Using Application Objects

Control Structures

1. If/Then
2. Immediate If
3. Case Statements
4. Choose Function

Looping Through Code

1. Looping Structures
2. For Next Loops
3. For Each
4. Do Loops
5. Do While
6. Do Until
7. Do Loop While
8. Do Loop Until

Handling Errors

1. Types of Errors
2. Error Handling Terminology
3. Creating An Error Handler
4. Using The Err Object
5. Exiting Error Handler Routine
6. Error Handling Templates

Debugging

1. Intro to Debugging
2. Navigating Your Code
3. Breakpoints
4. Working In Break Mode
5. Immediate Window
6. Locals Window
7. Watch Window

Data Access

1. Data Access Basics
2. Connection Object
3. Recordset Object
4. Referencing Fields
5. Navigating Records
6. SQL Queries
7. Updating Records
8. Adding Records Pt.1
9. Adding Records Pt.2
10. Deleting Records Pt.1
11. Deleting Records Pt.2
12. Connecting To SQL Server
13. DAO vs ADO

Application Completion

1. Documentation
2. Testing
3. Startup Options
4. Splash Screens
5. Packaging For Delivery
6. Using The Database Splitter

Credits

1. About The Author

About The Training Provider: The Virtual Training Company

More Microsoft Training from The Virtual Training Company

• Microsoft Access 2000
• Microsoft Access 2002
• Microsoft Access 2003
• Microsoft ASP NET
• Microsoft Entourage 2004
• Microsoft Excel 2000
• Microsoft Excel 2002
• Microsoft Excel 2003
• Microsoft Exchange 2000 Enterprise
• Microsoft Exchange 2003
• Microsoft FrontPage 2000
• Microsoft FrontPage 2002
• Microsoft FrontPage 2003
• Microsoft Internet Explorer 5 5
• Microsoft Managing Windows 2000 Security
• Microsoft Office 2001 for Macintosh
• Microsoft Office XP Upgrade
• Microsoft Outlook 2000
• Microsoft Outlook 2002
• Microsoft PowerPoint 2000
• Microsoft PowerPoint 2002
• Microsoft PowerPoint 2003
• Microsoft Project 2003
• Microsoft Publisher 2002
• Microsoft Publisher 2003
• Microsoft SQL Server 2005 Administration
• Microsoft Visio 2002
• Microsoft Visio 2003
• Microsoft Visual Basic 6
• Microsoft Visual Basic 6 Advanced
• Microsoft Visual Basic for Access
• Microsoft Visual Basic for Excel
• Microsoft Visual Basic NET
• Microsoft Visual Studio NET
• Microsoft Windows 2000 Directory Services
• Microsoft Windows 2000 Network Infrastructure
• Microsoft Windows 2000 Professional
• Microsoft Windows 2000 Server
• Microsoft Windows 95 Basics
• Microsoft Windows 98
• Microsoft Windows IIS 4
• Microsoft Windows NT 4 Server Admin
• Microsoft Windows NT 4 Server Installation
• Microsoft Windows NT 4 Workstation
• Microsoft Windows XP Administration 70-270
• Microsoft Windows XP Fundamentals
• Microsoft Word 2000
• Microsoft Word 2003