HomeSubscribeCoursesFAQAbout UsContact Us

Course Description

Microsoft Access VBA (Access Visual Basic) Programming Training Course 2003 - 2007

Microsoft Visual Basic for Applications (VBA) is part of the Microsoft Visual Basic family that that is used to program and extend the already powerful capabilities of applications such as Microsoft Access. VBA is an embeddable programming environment designed to enable programmers to build custom solutions using the full power of the Microsoft Visual Basic programming language. Developers using applications that host VBA can automate and extend the application functionality, shortening the development cycle of custom business solutions.

This online VBA for Access training course contains a series of video-based training tutorials designed for users want to use VBA to program Microsoft Access database, or those wanting to improve and consolidate their programming skills in the context of Microsoft Access. The course begins with the basics of VBA and quickly advances to cover the more advanced features, including Data Access technologies, Object Oriented Programming, error handling and much more.

Although there are significant changes in MS Access 2007, VBA remains the same whether you use Access 2003 or 2007. Consequently, even though the course materials are based on MS Excel 2003, the VBA concepts, principles and examples can also be applied to MS Excel 2007.

Excercise files can be downloaded by subscribed users who want follow along each tutorials.

Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.

Access VBA training

Training Courses

Microsoft Office 2007 Training

Microsoft Excel 2003 Training

Excel VBA Training

Microsoft Access 2007 Training

Microsoft Access 2003 Training

Access VBA Training

Dreamweaver 8 Training

PowerPoint 2003 Training

Windows XP Training

Please see below the online Access VBA (Access Visual Basic) training course outline. All tutorials will be activated immediately when you subscribe. Subscribe now or try a sample tutorial below

Sample tutorial: Updating Database Records

Training Course Outline

Introduction

Getting Started

What is VBA?

Accessing the VBA editor

The VBA interface

VBA code writing

VBA help

Variables

Defining & creating variables

Data types

Constants

Static variables

Option explicit & option compare

Variable scope

Procedures and Modules

Exploring procedures

Exploring modules

Using arguments

Function procedures

Code readability

Object Oriented Programming

Creating a class & object I

Creating a class & object II

The object browser

Using system classes

Event Programming

Events & event handler

Using events

Using form events

Working with Multiple Forms

Using docmd

Forms collection

Managing multiple forms

Validating Data

Validating levels

Data validation I

Data validation II

Control Structures - Decision Making

If...Then...Else

Select case statements

Choose function

With statement

Control Structures - Looping

For ... Next statement

For each statement

Do while statement

Do until statement

Do loop while & do loop until

Data Access

Introduction to data access

Creating ADO objects

Binding data

Using queries

Updating records

Adding records

Archiving records

Deleting records

Data Access Objects (ADO)

Error Handling & Debugging

Errors & error handling I

Errors & error handling II

The resume statement

Obtaining error information

Debugging & navigating your code

Working in break mode

The immediate window

The locals window

The watch window

Application Completion

Testing

Creating a splash screen

Packaging the application

Splitting the database

	Microsoft Office 2007 Training \| Excel Training \| Microsoft Access Training \| Excel VBA Training \| Access VBA Training
	Dreamweaver Training \| PowerPoint Training \| WindowsXP Training \| Course List