Microsoft Visual Basic for Access 2002 Video Tutorial - Training CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• 'Your training CDs are great and I will recommend [them] to everyone interested in learning software.'
  David Easter
  Brooklyn, NY ;

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Select your PlayBack Preference
QuickTime Flash

Topics covered on this Tutorial Video
are Listed Below:-

Introduction

• Tutorials Intro
• Course Overview
• Who This Course Is For

Microsoft VBA Basics

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

Variables in VB for Access

• Variables Explained
• Creating Variables
• VBA Data Types
• Expressions
• Constants
• Static Variables in Visual Basic for Access
• Option Explicit
• Variable Scope
• Option Compare

The purchased version of this product contains all the movies listed below as well as all the featured samples above. US$ 99.95

VBA Modules

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

Event Based Programming in VBA

• Visual Basic for Access Events
• Handling Events
• Choosing Events
• Form Events
• Control Events
• DoCmd Tutorials

Forms

• Collections
• Forms Collection
• Multiple Forms

Validating Data using VB for Access

• VBA Validation Levels
• Database Validation
• Code Level Validation
• Validating Strings in Visual Basic for Access
• Validating Numbers
• Validating Dates

Object Oriented Programming

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

VBA Control Structures

• If/Then
• Immediate If
• Visual Basic for Access Case Statements
• Choose Function

Looping Through Code

• Visual Basic for Access Looping Structures
• For Next Loops
• For Each
• Do Loops Tutorials
• 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 VBA

• Intro to Debugging
• Navigating Your Code
• Visual Basic for Access Breakpoints
• Working In Break Mode
• Immediate Window
• Locals Window Tutorials
• Watch Window

VBA for Data Access

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

Application Completion

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

Credits

• About The Author

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft Visual Basic for Access 2002 Training - INFO

TitleMicrosoft Visual Basic for Access 2002

TutorMark Long / Certified Instructor

Duration7 hours - 94 Movies

Price US$ 99.95

OSWin Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33548