Stricklen Solutions Logo
Search
View Store
Main Menu

Introduction to Access VBA Programming

LEVEL: INTERMEDIATE

This hands-on course is an introduction to programming with Visual Basic for Applications (VBA) in Microsoft Access. Students will learn how to work with loops, functions, control structures, object variables, arrays, and much more. By the end of the course participants will have the essential skills required to write their own procedures, automate data analysis and reporting, and develop a simple Access database application using VBA. No programming experience is required.

This course is taught by Steve Stricklen, who’s created countless Access VBA applications in his 20 years as a developer and trainer.

You Will Learn How To:

  • Write Your Own Procedures
  • Automate Data Analysis and Reporting
  • Use VBA to Transfer Data from Access to Excel (and vice versa)
  • Build a Simple Database Application
  • And Much More!

Other Benefits of Access VBA Training:

  • Instructor Support After the Training
  • Discounts on any of our Excel Add-ins
Stricken Solutions Online Training

Choose the Best Training Solution For You or Your Organization

Open Enrollment

2-Day Live,
Instructor-Led

Online Access VBA training via Zoom
View Schedule

Team Training

Online or On-Site,
Customizable

Live, instructor-led training for your group or staff
Contact Us

Access VBA Introduction Course Information

  • The public course is two days, 9-4 CST. Please see the schedule for more details.
  • For private groups this course can be conducted in a 2 or 3 day format, and can be customized. The third day can be used to cover a specific project or example.

This is an Access VBA Workshop. It's hands-on. The students will spend most of their time writing code, following along with a live instructor. Some PowerPoint slides and other documents may be used in the training but the student will spend very little time reading. Example files and other digital training material needed by the student will be emailed in advance or shared during the course.

  • Intermediate Access Skills
  • No Programming Experience Required
  • This course requires Microsoft Access 2007 or later versions
  • Instructor will be using Office 365 / Windows 11
  • Access is not available on Mac.

Our 200+ page Introduction to Access VBA Programming booklet is optional. While we do use it as a guide for the training, it is not required by the student to follow along with the instructor.

The booklet, however, does serve as an excellent reference after the training and includes additional exercises, examples, and quick-reference sheets. And it can be branded with your company's logo and colors. Great for team training!

Access VBA Introduction Course Outline

  • What is VBA?
  • Why Learn to Program with VBA?
  • The Programmer's Edge
  1. The Access Development Environment
  2. The Importance of Splitting Databases
  3. Maintaining Links
  4. Using the Database Splitter
  5. Using Queries for Reports and Forms
  6. Understanding Client/Server
  1. Macro Overview
  2. Creating Macros
  3. Assigning Macros
  4. Creating More Complex Macros
  5. Converting Macros to VBA Code
  6. When to Use Macros
  1. Programming Environment Overview
  2. The Role of Forms
  3. Creating a Startup Form
  4. Understanding Modules
  5. Code Behind Forms
  6. Standard Code Modules
  7. Standard vs. Class Modules
  1. Understanding Modules in Access
  2. The Anatomy of a Module
  3. Creating a Subroutine
  4. Creating a Function
  5. Calling Procedures
  6. Passing Parameters
  7. Returning Values
  1. Overview of Variables
  2. Creating String Variables
  3. Option Explicit
  4. Working with Numbers
  5. Dealing with Overflows
  6. Working with Decimals
  7. Working with Dates
  8. Default Values
  9. Scoping Variables
  10. Local Variables
  11. Module-Wide Variables
  12. Passing Arguments
  1. The Act of Communicating
  2. Creating a Simple Input Box
  3. Creating More Elaborate Input Boxes
  4. Global Positioning
  5. Simple Message Boxes
  6. Creating Larger Messages
  7. Breaking a Message Line
  8. Customizing Icons and Buttons
  9. Message Box Functions
  10. Responding to Different Buttons
  1. Decisions Overview
  2. Creating an In-Line If
  3. Creating a Block If
  4. Multiple If
  5. Multiple If Using Text
  6. Using Case Statements
  7. Value Ranges in Case Statements
  8. Case Statements with OR
  9. Asking Yes/No Questions
  1. Program Loops
  2. Creating a While Loop
  3. Taking Care of Counters
  4. Creating an Until Loop
  5. For Each Loops
  6. Exiting From Loops
  7. For Next Loops
  1. Overview of DoCmd
  2. Navigating with DoCmd
  3. Moving Through Records
  4. Filtering Records with DoCmd
  5. Opening a Form with DoCmd
  6. Opening a Report with DoCmd
  7. Closing a Form
  8. Creating Variable Reports
  1. Overview of ADO
  2. Setting References Using VBA
  3. Creating a Table with ADO
  4. Removing a Table Using ADO
  5. Populating a Form Using ADO
  6. Dealing with an Empty Table
  1. Overview of ADO Recordsets
  2. Navigating Records in a Form
  3. Finding a Record
  4. Updating a Record
  5. Deleting a Record
  6. Adding a New Record
  1. Overview of Debugging
  2. Setting a Breakpoint
  3. Setting Additional Breakpoints
  4. Stepping Through a Procedure
  5. Viewing the Call Stack
  6. Using the Locals Window
  7. Using the Immediate Window
  8. Adding a Watch
  9. Deleting a Watch
  1. Error Handling Overview
  2. Understanding Common Errors
  3. Creating a Simple Error Handler
  4. Understanding the Error Object Model
  5. More Elegant Error Handling
  6. Resuming From Errors
  7. Forcing an Error
  8. Creating Custom Errors
  • What's Next?
  • Where to Get Help
  • Writing Code
  • Think Like a Programmer

Access VBA Introduction Training FAQs

This course is applicable to Access 2007 and newer versions. Instructor will be using Office 365/Win 11.

Windows PC is required for the course.

Yes, individuals can enroll in one of our open-enrollment courses, which are conducted online using Zoom. 

Or, for organizations, we can teach your group or staff in a private online session using an online service you choose. Private sessions can also be customized.

Our public courses are guaranteed to run. If, for some reason, the course does not occur, you will receive a full refund.

100% Satisfaction Guarantee!*

* Contact us for more details

Questions about the Access VBA Training?

Let us know how we can help. We’ll get in touch within one business day.

"An excellent introduction to programming with VBA"
Ryan G.
Financial Analyst
SERVICES
VBA COURSES
COMPANY
CONNECT
Linkedin Facebook-f Twitter