Duration: 7 hrs
In this Visual Basic for Access tutorial you will learn how use Visual Basic to construct and publish your own programs. Expert author Mark Long covers event programming, code control structures, constants, variables, and more.
Intro
Welcome
Visual Basic for Access 2002 Tutorial Overview
Who This Course Targeted Towards
VBA Basics
This is VBA
VBA IDE
Project Window in VBA
Properties Window Described
The Custom Toolbar
Writing Code - Overview
Gaining Assistance In VBA
Variables
Chapter Overview
The Creation of Variables
Data Types
Expressions Explained
Constants
Static Variables
Option Explicit
Variable Scope
Option Compare
Modules
Chapter Overview
Procedures in VB
Making use of Arguments
Public vs Private
Functions
Making use of Form Modules
Making use of Standard Modules
Improving Code Readability
Event Based Programming
Chapter Overview
Events:
o How to Handle
o Choosing
o Form
o Control Events
DoCmd
Forms
Collections Overview
Forms Collection
Multiple Forms Explained
Validating Data
The Levels of Validation
Database and Code Level Validation
How To Validate:
o Strings
o Numbers
o Dates
Object Oriented Programming
Chapter Overview
Classes
Objects
The Creation of a Class
The Creation of An Object
Object Browser
Applying Application Objects
Control Structures
If/Then
Immediate If
Case Statements in VB
Using the Choose Function
Looping Through Code
Looping Structures Overview
For Next Loops
For Each
Do Loops
Do While
Do Until
Do Loop While
Do Loop Until
Handling Errors
Types of Errors Described
The Terminology of Error Handling
The Creation of An Error Handler
Applying The Err Object
Exiting Error Handler Routine
Error Handling Templates
Debugging
Chapter Overview
Navigating Through Your Code
Breakpoints
Working In Break Mode
Immediate Window
Locals Window
Watch Window
Data Access
Chapter Overview
Connection Object
Recordset Object
Referencing Fields
Navigating Records
SQL Queries
How to Update Records
Adding Records (2 Parts)
Deleting Records (2 Parts)
How to Connect To an SQL Server
DAO versus ADO
Application Completion
Documentation
Testing
Startup Options
Splash Screens
Packaging For Delivery
Applying The Database Splitter Author Details |
