Access VBA: The Beginner's Blueprint to Programming Access
4.5 (93 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,574 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Access VBA: The Beginner's Blueprint to Programming Access to your Wishlist.

Add to Wishlist

Access VBA: The Beginner's Blueprint to Programming Access

Don't Just Use Your Microsoft Access Databases... Program Them with the Tools Found in This Course!
4.5 (93 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,574 students enrolled
Created by IsáBel Harrison
Last updated 7/2017
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 4.5 hours on-demand video
  • 25 Articles
  • 66 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • UNDERSTAND why you would want to use VBA in Access Databases
  • KNOW the differences between Macros and VBA
  • CREATE a simple Macro in Access
  • NAVIGATE comfortably in the Visual Basic Editor
  • LEARN the essentials of writing Access VBA code
  • PROGRAM command buttons
  • CREATE decision structures
  • CREATE user interaction dialog boxes, like message boxes and input boxes
  • DEBUG your VBA code
  • LEARN how to handle errors
  • USE built in String, Date, and Format functions
View Curriculum
  • Access 2007, 2010, 2013, 2016
  • To get the most out of this course, you should have working knowledge of Microsoft Access databases

Choose Access VBA when...

Simple tables, forms, or reports just won't do. ..
When Macros aren't quite enough. ..
And when creating your own applications from scratch is overkill. 

Are you experienced with Access, but not with VBA programming? 

This course introduces VBA programming concepts with easy to follow examples, and lessons.


First, you will learn the difference between Macros and VBA, and create a simple Macro.

Then you will get familiar with the Visual Basic Editor, your home for programming Access, and basic concepts of Visual Basic for Applications.

During this course you will learn VBA concepts that you can apply to your job, and add functionality to your Access databases:

  • Get comfortable with the Visual Basic Editor (VBE)
  • Learn the essentials of writing VBA code
  • Learn about the powerful DoCmd object
  • Create branching decision structures
  • Create user interactions forms, like message boxes, and input boxes
  • DAO recordsets
  • Debug your code, and handle errors


What to know before you enroll:

You will have unlimited, lifetime access to the course!

You will have instant, and free access to any updates I add to the course.

Don't forget, you are covered by a 30 day money back guarantee.


Get started programming VBA for your Access databases today.

Who is the target audience?
  • The Beginning Access VBA Programmer
  • Programmers of other languages that would like a good tutorial
  • Anyone who is responsible for working with Access databases
  • Anyone wanting to know more about Access VBA
Compare to Other Access VBA Courses
Curriculum For This Course
140 Lectures
1 Lecture 01:48

Welcome to Access VBA: Beginner's Blueprint to Programming Access VBA.

IsaBel Harrison |

Preview 01:48
Creating Macros in Microsoft Access
3 Lectures 12:53

When programming your Access databases, you have a choice of Macros, or VBA.
Which should you choose?
Learn the difference with this lecture.

Preview 02:14

Learn how to create a simple macro in your Access database.

Preview 06:41

Learn how to take your macro and turn it into VBA code.

Preview 03:58
Getting Familiar with the VBE (Visual Basic Editor)
12 Lectures 17:22

There are multiple ways to access the Visual Basic Editor.

Take a few seconds to learn them now.

Preview 01:13

Get familiar with the different windows that you will be using when programming your Excel VBA code.

Preview 06:31

You will see Option Compare Database, and Option Explicit a lot throughout this course, but what do they mean?

Preview 1 page

You will need to create your own code modules, and it is as easy as a couple of mouse clicks. Learn how to here.

Preview 01:22

Learn how to export, and import VBA code modules.

Preview 2 pages

Keep your code modules organized by naming any module that you create.

Naming Modules

To be comfortable writing VBA, you need to be comfortable in the VBE.

Learn how to customize the VBE to meet your needs.

Options for Customizing the Visual Basic Editor
5 pages

Browse through your project's available objects, and see their properties, methods, and events.

The Object Browser
1 page

Learn how you can password protect your VBA code modules.

Password Protecting Your VBA Code
1 page

When programming VBA, knowing a few time savers can go a long way.

A Few Time Savers When Writing VBA

If you get an error while programming your VBA that stops your code from running, don't stress.

Reset your code, and edit your code if you can.

What to do When You Have Error in Your Code?

Key Points for the Section: Getting Familiar with the VBE (Visual Basic Environment)

Section Summary
Getting Started with Programming in VBA
11 Lectures 20:16

Get a brief overview of OOP, and how it plays a major role in this VBA programming course.

Object Oriented Programming

Learn how VBA accesses an object's properties, and methods.

How VBA Accesses an Object's Properties and Methods

Procedures are the container that you will be storing your code in.

Working with Procedures

A quick lecture on how to structure your sub procedures.

Structure of Sub Procedures

Learn how the structure of a function differs from the structure of a sub procedure.

Structure of Functions

Being able to use procedures throughout your module has many benefits.

Learn how to call your procedures in your VBA code.

Calling a Sub Procedure or Function

How do you call one procedure with the same name as another?

Calling Procedures with the Same Name

A click of a mouse, or the loading of a form, these are both events that can trigger your code to run.

In this lecture, learn about, and how to create, event procedures.

Event Procedures

Collections are a group of similar object.

Using collections can save you time when programming in VBA.


You can use comments to make notes in your code. It is very helpful, and highly recommended.


Key Points for the Section: Object Oriented Programming

Section Summary
Getting to Know Variables, Data Types, and Operators
21 Lectures 45:47

An introduction to topics covered in this section


Declaring a variable lets VBA know that you want to store a value in the computer's memory.

Variable Declaration

Data types are a key component to programming. In this lecture find out why.

The Importance of Data Types

A list of VBA's built-in data types.

VBA's Built-in Data Types
1 page

You can also declare variable's data types with Identifier Type Characters

Using Identifier Type Characers to Declare Data Types
1 page

Learn how to speed up the programming of your code by using Me.

About "Me"

Constants are placeholders for information that do not change through the life of your code.

Declaring Constants

Learn how Object Variables can save you time when writing your VBA.

Object Variables

Arithmetic Operators

Arithmetic Operators
1 page

An exercise in using arithetic operators.

Exercise: Arithmetic Operators

You type a number in a text box, but is it really seen as a numeric value?

Text Box Values

Bring multiple strings together with String Contatenation

String Concatenation

An exercise on string concatenation.

Exercise: String Concatenation

When you want to wrap your VBA code around to multiple lines, use the Line Continuation Operator

The Line Continuation Operator

Learn how to use the Colon operator in VBA

The Colon Operator

Use the Carriage Return Line Feed to display strings on multiple lines.

Carriage Return-Line Feed

Using the With statement is a real time saver, find out why.

The With Statement

Setting the scope of your variables determines where those variables can be used.

Controlling Access of Your Variables & Procedures with Scope

An explanation of Arrays used in VBA


Test the skills you learned in this section with this exercise.

Test Your Skills

Key Points for the Sections: The Essentials to Programming in VBA

Section Summary
18 Lectures 22:45

An introduction to this section.

Introduction to Functions

Learn to extract data with the Left, Right, and Mid functions.

String Functions: Left, Right, and Mid

Change the case of your strings with UCase, and LCase

String Functions: UCase, and LCase

Locate characters in a string with the InStr function.

String Functions: InStr

The simple Date, and Now functions can be used as time stamps in your databases.

Date and Time Functions: Date, and Now

Learn how to extract the Day, Month, and Year from a date parameter.

Date and Time Functions: Day, Month, and Year

Calculate the difference between two dates.

Date and Time Functions: DateDiff

Learn the simple function to display the time of day.

Date and Time Functions: Time

Learn how to extract the second, minute, and hour, from a time parameter.

Date and Time Functions: Second, Minute, and Hour

Learn how to format your numbers with these common functions.

The Format Function: Using Named Format Expressions

Learn to create your own custom number formatting.

The Format Function: Creating Custom Number Formats
3 pages

Learn how to create custom date and time formats.

The Format Function: Creating Custom Date/Time Formatting
2 pages

Learn how to create custom string formats.

The Format Function: Creating Custom String Formats
1 page

Learn how to use the FormatCurrency function.

Using the FormatCurrency Function

Learn how to use the FormatNumber function.

The FormatNumber Function

Learn how to use the FormatDateTime function.

Using the FormatDateTime Function
1 page

Learn how to use the FormatPercent function.

The FormatPercent Function

Test the skills you have learn in the Formatting section, and apply them to this exercise.

Test Your Skills
Events Attached to Access Database Objects Explained
10 Lectures 05:37

An overview of Object events

Overview of Object Events

Learn about using click events to trigger your code to run.

Click Events

Learn about using focus events to trigger your code to run.

Focus Events

Learn about using mouse events to trigger your code to run.

Mouse Events

Learn about using keyboard events to trigger your code to run.

Keyboard Events

Learn about using text box events to trigger your code to run.

Text box Events

Combo box Events

Combo box Events

Learn about using form events to trigger your code to run.

Form Events
2 pages

Learn about using report events to trigger your code to run.

Report Events
1 page

Test the skill you learned in this section to complete the exercise in this lecture.

Test Your Skills
Introductions to DoCmd Methods
14 Lectures 43:20

Learn how much easier the DoCmd object will make your programming.

Introduction to DoCmd

Learn how to filter records with the ApplyFilter method.

DoCmd ApplyFilter

Learn how to copy objects in your database with the CopyObject method.

DoCmd CopyObject

Learn how to quickly open forms with the OpenForm method.

DoCmd OpenForm

Learn how to quickly open reports with the OpenReport method.

DoCmd OpenReport

Learn how to quickly open tables with the OpenTable method.

DoCmd OpenTable

Learn how to turn objects into PDFs or other formats with the OutputTo method.

DoCmd OutputTo

Learn how to access menu commands with the RunCommand option.

DoCmd RunCommand

An exercise on using a DoCmd method to create an Outlook contact.

Exercise: Creating an Outlook Contact
2 pages

Learn how to run SQL in your VBA code with the RunSQL method.

DoCmd RunSQL

Learn how to e-mail objects with the SendObject method.

DoCmd SendObject

Learn to use the TransferDatabase method.

DoCmd TransferDatabase

Use TransferSpreadsheet to import, export, or link Excel worksheets to Access.

DoCmd TransferSpreadsheet

Key points for the Introductions to DoCmd Methods section.

Section Summary
Decisions Structures
7 Lectures 16:51

Learn how to branch your VBA code, by using If... then...else

The IF THEN Statement

An exercise using If Then Else

Exercise: The IF THEN Statement
2 pages

The Select Case statement is another way to branch your VBA code.

The Select Case Statement

An exercise using Select Case.

Exercise: Select Case
2 pages

Test your If..Then skills with this exercise.

Test Your Skills

Test your Select Case skills with this exercise.

Test Your Skills II

Key Points for the Section: Decisions Structures

Section Summary
Creating User Interactions with Message Boxes & Input Boxes
5 Lectures 15:07

How are you enjoying the course so far?

How Are You Enjoying the Course?
1 page

Learn the syntax for creating message boxes in VBA.

Message Boxes

Learn the syntax for creating Input Boxes in VBA

Input Boxes

An exercise using input boxes and message boxes.

Exercise: Input Boxes & Message Boxes

Key Points for the Section: Creating User Interactions with Message Boxes & Input Boxes

Section Summary
5 More Sections
About the Instructor
IsáBel Harrison
4.5 Average rating
1,061 Reviews
15,740 Students
16 Courses
Results & Convenience | Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.

Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, then ▶Subscribe to My YouTube Channel, because Change Matters, Growth Matters.