Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

In this software training course from expert author and trainer Guy Vaccaro, you will learn how to use Visual Basic with Microsoft Access. Knowing how to use Visual Basic with Microsoft Access gives you greater control of your Access forms and design. You will start with an introduction to VBA and the VBA editor, how to navigate and use the tools available to you to write VBA code. You will explore variables and constants, functions, sub routines, arrays and other VBA constructs. This video based training will teach you to use VBA for data manipulation, create and use recordsets, controlling objects, create and use dialog and message boxes, debugging, and creating error messages. Finally, you will learn to protect your VBA programs. By the completion of this training video, you will be comfortable with using Visual Basic for Access to exert greater control over your Microsoft Access forms and databases. Working Files are included to allow you to work alongside the author in this video tutorial.

Subscriber Reviews

Average Rating: 5 out of 5 rating Based on 1 Rating

"Learning Visual Basic for Microsoft Access" - by TonyB on 16-NOV-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
What I would have given for this video series years ago! I watched this over a 3 day period and really learned some of the basics of what I was already doing - only now, I actually understand what I was doing! VERY WELL DONE!
Report as Inappropriate

Table of Contents

Chapter/Selection

Time

01. Introducing VBA For Access

Can I Really Become A Programmer

Play Video

00:02:52

About The Author

Play Video

00:01:30

Using The Working Files

Play Video

00:01:59

Initial Setup Of The Sample Databases Provided

Play Video

00:02:44

02. Moving From A Database To An Application

What Is VBA

Play Video

00:03:20

Where Is The VBA

Play Video

00:04:38

The VBA Editor Quick Tour

Play Video

00:02:33

The Editor - Explorer And Properties Windows

Play Video

00:02:50

The Editor - The Debug Window

Play Video

00:02:45

Macros Or VBA - Convert Your Macro To Code

Play Video

00:03:19

03. Programming In VBA

Getting Started With A Standard Module

Play Video

00:02:11

Creating A Procedure

Play Video

00:02:55

Adding Comments To Your Code

Play Video

00:02:10

VBA Data Types

Play Video

00:02:38

Declaring Parameters For Use In Procedures

Play Video

00:04:30

How To Declare Variables And Constants

Play Video

00:05:09

Creating And Assigning Array Values

Play Video

00:04:21

The Scope And Lifetime Of Variables

Play Video

00:03:33

Standard Naming Conventions For Variables

Play Video

00:03:24

Handling Multiple Line Commands

Play Video

00:03:44

The Very Useful Keyword - ME

Play Video

00:02:45

04. Repeating VBA Code

Do Loop

Preview

00:04:34

While Wend

Preview

00:01:54

For Next

Preview

00:04:47

If Else End If

Preview

00:07:02

The Very Flexible Select Case Statement

Preview

00:05:16

05. Working With Access Objects

The Access Object Model

Preview

00:07:23

Changing The Value Of Object Properties

Preview

00:04:14

Access Special Object DoCmd

Preview

00:03:52

Class Modules And Class Procedures

Preview

00:04:35

Enable And Disable Controls

Preview

00:05:41

Hide Or Show Form Controls

Preview

00:05:47

Lock Unlock Controls

Preview

00:02:52

Form Events To Trigger Procedures

Preview

00:05:48

Setting Color Properties

Preview

00:07:19

Defining Your Own Custom Colours

Preview

00:08:09

Defining Font Properties Through Your Code

Preview

00:05:46

With End With To Shorten Code Writing

Preview

00:02:47

Assigning Values To Data Fields On A Form

Preview

00:06:44

Opening A Form

Preview

00:05:28

Open Form And Display Filtered Dataset

Preview

00:06:40

Closing Any Open Form

Preview

00:06:00

06. Data Manipulation

A Very Quick SQL Tour

Preview

00:03:53

Running An Action Query As Code

Preview

00:04:50

Stop Warnings On Action Queries When Run In VBA

Preview

00:04:12

Building And Storing SQL In Variables

Preview

00:05:39

Changing The Sql That Populates A List Or Combo Box

Preview

00:04:28

Create A New Table

Preview

00:03:56

Deleting (And Closing) A Table

Preview

00:04:47

Adding Data To Tables Through Code

Preview

00:07:38

The Recordset Explained

Preview

00:07:29

How To Reference Fields In A Recordset

Preview

00:02:13

Navigating Through The Rows Of A Recordset

Preview

00:02:41

Closing Off A Recordset And ADODB Connection

Preview

00:02:14

The Recordset In Action

Preview

00:13:05

DCOUNT (Great Function)

Preview

00:06:09

07. Interacting With The User

Getting Started With The MSGBOX

Preview

00:07:13

Customizing The MSGBOX

Preview

00:06:11

Reacting To The User Response In A MSGBOX

Preview

00:06:04

Creating A Dialog Box

Preview

00:04:29

Using A Dialog To Give Choices To Users

Preview

00:07:46

Combo Box Dynamic List Building

Preview

00:06:01

Excluding Values From The Combo Box List

Preview

00:03:07

Using The Combo Box Selected Value

Preview

00:04:42

Detecting The Right Mouse Click

Preview

00:07:20

08. Combo And ListBox Specials

Combo Box And ListBox Properties

Preview

00:04:04

Accessing And Setting Combo And Field List Properties

Preview

00:09:12

Accessing Combo Box Fields From A Different Form

Preview

00:10:45

List Box Search Application

Preview

00:04:26

09. Functions

What Is A Function

Preview

00:02:21

Creating A Custom Function

Preview

00:04:17

A Proper ProperCase Function

Preview

00:06:53

10. Testing, Error Handling And Debugging

The Three Types Of Errors

Preview

00:04:48

Handling Logical Errors With Debug Print

Preview

00:05:39

Handling Logical Errors With Breakpoints

Preview

00:05:46

Creating Your Own Runtime Error Handler

Preview

00:06:07

Specific Error Messages For Specific Errors

Preview

00:06:51

11. And Finally

Locking The VBA From Prying Eyes

Preview

00:02:57

So What's Next

Preview

00:03:13

Extras

The publisher has provided additional content related to this title.


Description
Content

These files have been provided by the publisher.

  • Working_Files.zip