30% OFF Marked Prices & FREE Shipping!   -   ENDS 5PM FRIDAY!   -   Use Discount Code 303

Microsoft Visual Basic for Access Tutorial

A professionally created, self-study video training course
Includes 7 hours of easy to follow Microsoft Visual Basic for Access video tutorials presented by an industry expert.
The training is delivered to your desktop allowing you to learn at a time that suits you and at your own pace.
You can start learning online right away. Sample Microsoft Visual Basic for Access tutorial videos by clicking a blue link below:
  • Tutor: Guy Vaccaro
  • Duration: 7 hours
  • Video lessons: 79
  • Product code: 01683
  • In stock: YES
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 vba 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.
The same work files that Guy uses are also included in the DVD / Download purchase, which allows you to easily replicate the on-screen actions and effortlessly keep pace with his verbal instructions.

The complete training course contents are listed below and you can start this learning high-level, general purpose programming language right away, click any blue linked lesson to sample FREE Microsoft Visual Basic for Access video tutorials and discover how effective this teaching guide really is...
What Our Customers Are Saying

"Your training cds have been invaluable and i am going to be ordering some more. I have developed new skills really fast at a low cost. Once again, thanks a lot."Andrew Fast, Freelance Photographer
We hope you enjoyed the free lessons. To view the complete contents, including all lessons below & above, please purchase the course via Download.
Paid Content

Get all lessons with purchase
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
VB Do Loop
VB 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
Purchase Info - 30% OFF MARKED PRICE!
This course is available via digital download and is priced as below:
Once purchased, you will receive 79 Microsoft Visual Basic for Access training videos (listed left), lasting a total of 7 hours and the working files.

Delivery Details
Download Course downloadable when payment processed (within one hour average)
All DVD courses have a 100% money back guarantee. If you are not happy with your course contact us within 30 days of purchase for a refund.
View our full product guarantee
Need to Train Multiple Users?
This Microsoft Visual Basic for Access course is available in multi-user format ideal for corporate users, schools and universities.

The course loads directly onto your server and delivered to multiple users over your network.

An unlimited number of users can access the training with a pre-determined number viewing the tuition at any one time.

Training Multiple Users

Load onto your server
Deliver on your network or existing learning management system

For companies and educational establishments wanting multi user access to training resources, we offer this Microsoft Visual Basic for Access course to do just that.
Now you can integrate training or technical support within your own computer network, or allow employees or students to gain access to training and support from home or any other location that they can gain access to your organizations network.

The courses can be played over a LAN using a standard browser such as Microsoft Internet Explorer, Safari or Firefox.
The movies are viewed using Adobe Flash (same method as YouTube) and are slightly compressed in order to not clog the network.
All advanced and the "for dummies" courses are available via this multi user solution and can be copied directly to a hard disk for faster access and the access page may be customized, if needed, using a html editor.

More than one title can exist on your server and the supplied player will automatically show titles that are available.
Simply purchase more user licences (supplied as files) and drop them into the folder. This will automatically increase the number of users allowed onto the system. All purchases are backed up by excellent after-sales support team and easy to follow instruction manual.
You can order multi user online or speak to our knowledgeable sales team.
Multi users are sold in 10 user licenses. For each 10 user licenses, you can have up to 10 people viewing that training at any one time.
Closely Related Courses
See our complete range of Microsoft Office 2013 Tutorials
See our complete range of Microsoft Visual Basic Tutorials
Prove Your Capabilities
Once a course is completed you can download a free certificate.

This certifies that you have started from the beginners level, have now viewed all instruction. The certificate advises you now possess essential skills and an in-depth knowledge of Microsoft Visual Basic for Access. Show your boss or potential employer!
Weekly Special
Promoted Course
View sample videos from the new
AutoCAD 2016
A recent customer speaks out...
"I have been recently been using your Photoshop training to demonstrate techniques to my students. I've been trying to persuade them to purchase it themselves, as I believe it to be an excellent training tool, and the best instructional CD on this subject to date by far! Not only is it easy to follow and presented clearly, but it is also a bargain."Joe Doyle Vista Community College, Berkeley, CA