Microsoft Access VBA Introduction for the Complete VBA Newb

Course Curriculum

Chapter 1: Getting Started with Microsoft Access VBA

Lecture 1: Quick Introduction

Lecture 2: Access VBA Intro – Section 1 Exercise File Download

Lecture 3: Introduction to the Access VBE (Visual Basic Editor) Window

Lecture 4: Getting Help with Access VBA

Chapter 2: Working with Access VBA SUB Procedures and Functions

Lecture 1: Access VBA SUB Procedures and Functions – Section 2 Exercise File Download

Lecture 2: Understanding and Creating VBA Modules

Lecture 3: Creating Access VBA SUB Procedures

Lecture 4: Calling an Access VBA SUB Procedure

Lecture 5: Using the Immediate Window

Lecture 6: Creating Access VBA Custom Functions

Lecture 7: Using an Access VBA Function

Chapter 3: Understanding and Working with Access Objects with VBA

Lecture 1: Access VBA Objects – Section 3 Exercise File Download

Lecture 2: Understanding Access Objects

Lecture 3: Properties, Methods and Events of Access Objects

Lecture 4: Communicating with Access Objects with VBA

Lecture 5: Working with Object Collections

Lecture 6: Using the VBA "With" Statement

Lecture 7: Controlling Access Objects with the "DoCmd" Statement

Chapter 4: Foundational VBA Programming Concepts

Lecture 1: Access VBA Programming Concepts – Section 4 Exercise File Download

Lecture 2: Storing and Referencing Data with VBA Variables

Lecture 3: Declaring a Variables Data Type

Lecture 4: Understanding the Scope of a VBA Variable

Lecture 5: Creating Logic within VBA Code Using an IF Statement

Lecture 6: Using a VBA Select Case Statement to Branch within Code

Lecture 7: Repeating Blocks of VBA Code with Loops

Chapter 5: Working with the Access Recordset Object

Lecture 1: Access VBA Recordset Object – Section 5 Exercise File Download

Lecture 2: Creating Object Variables

Lecture 3: Iterating through an Access Recordset

Chapter 6: Debugging Access VBA Code

Lecture 1: Access VBA Debugging Tools – Section 6 Exercise File Download

Lecture 2: Stepping Through Code a Line at a Time

Lecture 3: Setting Breakpoints with a Procedure

Lecture 4: Adding Error Handling to an Access VBA Procedure

Lecture 5: Using the Access VBA "Err" Object

Chapter 7: Access VBA – Project #1 Working with Access VBA SUB Procedures

Lecture 1: Project #1 – Introduction and Preview

Lecture 2: Project #1 – Exercise File Download

Lecture 3: Project #1 – Setting up the Form

Lecture 4: Project #1 – Where to Write Your Code

Lecture 5: Project #1 – Creating a SUB Procedure to Open a Form

Lecture 6: Project #1 – Working with the OnClick Event of a Command Button

Lecture 7: Project #1 – Making Reuasable SUB Procedures

Lecture 8: Project #1 – Quick Recap

Chapter 8: Congratulations and Bonus

Lecture 1: Congratulations! You've Completed the Course