Microsoft Visual Basic for Access 2002
Author:Mark Vernon
Language:english
Category:Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about Microsoft Visual Basic for Access 2002
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 2002Microsoft Visual Basic for Access 2002: Microsoft Visual Basic for Access 2002 Training 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. Microsoft Visual Basic for Access 2002
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft Visual Basic for Access 2002

Introduction

Welcome/Intro
Course Overview
Who This Course Is For

VBA Basics

This is VBA
VBA IDE
Project Window
Properties Window
Custom Toolbar
Writing Code
Getting Assistance In VBA

Variables

Variables Explained
Creating Variables
Data Types
Expressions
Constants
Static Variables
Option Explicit
Variable Scope
Option Compare

Modules

Intro to Modules
Procedures
Using Arguments
Public vs Private
Functions
Using Form Modules
Using Standard Modules
Enhancing Code Readability

Event Based Programming

Events
Handling Events
Choosing Events
Form Events
Control Events
DoCmd

Forms

Collections
Forms Collection
Multiple Forms

Validating Data

Validation Levels
Database Validation
Code Level Validation
Validating Strings
Validating Numbers
Validating Dates

Object Oriented Programming

Intro to OOP
Classes
Objects
Creating A Class
Creating An Object
Object Browser
Using Application Objects

Control Structures

If/Then
Immediate If
Case Statements
Choose Function

Looping Through Code

Looping Structures
For Next Loops
For Each
Do Loops
Do While
Do Until
Do Loop While
Do Loop Until

Handling Errors

Types of Errors
Error Handling Terminology
Creating An Error Handler
Using The Err Object
Exiting Error Handler Routine
Error Handling Templates

Debugging

Intro to Debugging
Navigating Your Code
Breakpoints
Working In Break Mode
Immediate Window
Locals Window
Watch Window

Data Access

Data Access Basics
Connection Object
Recordset Object
Referencing Fields
Navigating Records
SQL Queries
Updating Records
Adding Records Pt.1
Adding Records Pt.2
Deleting Records Pt.1
Deleting Records Pt.2
Connecting To SQL Server
DAO vs ADO

Application Completion

Documentation
Testing
Startup Options
Splash Screens
Packaging For Delivery
Using The Database Splitter

Credits

About The Author

01 Introduction
0101 Welcome/Intro
0102 Course Overview
0103 Who This Course Is For

02 VBA Basics
0201 This is VBA
0202 VBA IDE
0203 Project Window
0204 Properties Window
0205 Custom Toolbar
0206 Writing Code
0207 Getting Assistance In VBA

03 Variables
0301 Variables Explained
0302 Creating Variables
0303 Data Types
0304 Expressions
0305 Constants
0306 Static Variables
0307 Option Explicit
0308 Variable Scope
0309 Option Compare

04 Modules
0401 Intro to Modules
0402 Procedures
0403 Using Arguments
0404 Public vs Private
0405 Functions
0406 Using Form Modules
0407 Using Standard Modules
0408 Enhancing Code Readability

05 Event Based Programming
0501 Events
0502 Handling Events
0503 Choosing Events
0504 Form Events
0505 Control Events
0506 DoCmd

06 Forms
0601 Collections
0602 Forms Collection
0603 Multiple Forms

07 Validating Data
0701 Validation Levels
0702 Database Validation
0703 Code Level Validation
0704 Validating Strings
0705 Validating Numbers
0706 Validating Dates

08 Object Oriented Programming
0801 Intro to OOP
0802 Classes
0803 Objects
0804 Creating A Class
0805 Creating An Object
0806 Object Browser
0807 Using Application Objects

09 Control Structures
0901 If/Then
0902 Immediate If
0903 Case Statements
0904 Choose Function

10 Looping Through Code
1001 Looping Structures
1002 For Next Loops
1003 For Each
1004 Do Loops
1005 Do While
1006 Do Until
1007 Do Loop While
1008 Do Loop Until

11 Handling Errors
1101 Types of Errors
1102 Error Handling Terminology
1103 Creating An Error Handler
1104 Using The Err Object
1105 Exiting Error Handler Routine
1106 Error Handling Templates

12 Debugging
1201 Intro to Debugging
1202 Navigating Your Code
1203 Breakpoints
1204 Working In Break Mode
1205 Immediate Window
1206 Locals Window
1207 Watch Window

13 Data Access
1301 Data Access Basics
1302 Connection Object
1303 Recordset Object
1304 Referencing Fields
1305 Navigating Records
1306 SQL Queries
1307 Updating Records
1308 Adding Records Pt.1
1309 Adding Records Pt.2
1310 Deleting Records Pt.1
1311 Deleting Records Pt.2
1312 Connecting To SQL Server
1313 DAO vs ADO

14 Application Completion
1401 Documentation
1402 Testing
1403 Startup Options
1404 Splash Screens
1405 Packaging For Delivery
1406 Using The Database Splitter

15 Credits
1501 About The Author

Sponsors