Visual Basic for Access Video Tutorial Course

CareerVision Training

£ 70 - (Rs 5,707)
VAT incl.

Important information

  • Training
  • Beginner
  • Distance learning
  • Duration:
  • When:
  • Delivery of study materials

• Format: DVD-ROM
• Duration: 6.5 Hours (79 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac
Gain the skills and knowledge to use this powerful programming language to provide greater control over your MS Access forms and databases with the help of these beginners Microsoft Visual Basic for Access tutorial videos.
Commencing from the absolute basics, expert VBA tutor Guy Vaccaro presents step-by-step training videos that explain the important concepts and best practices that will transform you from beginner to confident and proficient VBA programmer in a very short space of time.
Through over six hours of professionally created training videos, the tuition includes the basics of writing VBA code, help using the VBA editor, learning VBA datatypes, how to repeat VBA code, lessons on creating a procedure and so much more.

Important information

Requirements: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.


Where and when

Starts Location
Distance Learning

What you'll learn on the course

Access Features
VBA Code
Database Setup
Multiple Line Command
Commenting Code

Course programme

Introducing VBA For Access

Can I Really Become A Programmer

About The VBA Tutor

Using The Working Files

Initial Setup Of The Sample Databases Provided

Moving From A Database To An Application

What Is VBA

Where Is The VBA

The VBA Editor Quick Tour

The VB Editor - Explorer And Properties Windows

The VB Editor - The Debug Window

Macros Or VBA - Convert Your Macro To Code

Programming In VBA

Getting Started With A Standard Module

Creating A Procedure

Adding Comments To Your Code

VBA Data Types

Declaring Parameters For Use In Procedures

How To Declare Variables And Constants

Creating And Assigning Array Values

The Scope And Lifetime Of Variables

Standard Naming Conventions For Variables

Handling Multiple Line Commands

The Very Useful Keyword - ME

Repeating VBA Code

Do Loop

While Wend

For Next

If Else End If

The Very Flexible Select Case Statement

Working With Access Objects

The Access Object Model

Changing The Value Of Object Properties

Access Special Object DoCmd

Class Modules And Class Procedures

Enable And Disable Controls

Hide Or Show Form Controls

Lock Unlock Controls

Form Events To Trigger Procedures

Setting Color Properties

Defining Your Own Custom Colours

Defining Font Properties Through Your Code

With End With To Shorten Code Writing

Assigning Values To Data Fields On A Form

Opening A Form

Open Form And Display Filtered Dataset

Closing Any Open Form

Data Manipulation

A Very Quick SQL Tour

Running An Action Query As Code

Stop Warnings On Action Queries When Run In VBA

Building And Storing SQL In Variables

Changing The Sql That Populates A List Or Combo Box

Create A New Table

Deleting (And Closing) A Table

Adding Data To Tables Through Code

The Recordset Explained

How To Reference Fields In A Recordset

Navigating Through The Rows Of A Recordset

Closing Off A Recordset And ADODB Connection

The Recordset In Action

DCOUNT (Great Function)

Interacting With The User

Getting Started With The MSGBOX

Customizing The MSGBOX

Reacting To The User Response In A MSGBOX

Creating A Dialog Box

Using A Dialog To Give Choices To Users

Combo Box Dynamic List Building

Excluding Values From The Combo Box List

Using The Combo Box Selected Value

Detecting The Right Mouse Click

Combo And ListBox Specials

Combo Box And ListBox Properties

Accessing And Setting Combo And Field List Properties

Accessing Combo Box Fields From A Different Form

List Box Search Application


What Is A Function

Creating A Custom Function

A Proper ProperCase Function

Testing, Error Handling And Debugging

The Three Types Of Errors

Handling Logical Errors With Debug Print

Handling Logical Errors With Breakpoints

Creating Your Own Runtime Error Handler

Specific Error Messages For Specific Errors

And Finally

Locking The VBA From Prying Eyes

So What's Next

MS VBA Course Wrap Up