Access VBA training

Getting Started with Access VBA

Get productive fast by learning how to edit your code with the fewest clicks. In this introduction to the Access VBA editing environment, we start with a simple project and walk you through the steps needed to:

Create and manage projects using the Project Explorer
Edit programs in the color-coded editor
Inspect and set properties in the Property Window
Execute programs, debug code, and manage plug-ins from the Tools menu

Working with Procedures and Functions

The secret of writing maintainable and reusable code is employing industry best practices. In this part of the MS Access training course, we teach you the best way to organize your code by placing program statements and expressions in task-oriented procedures and functions, and then grouping them into a larger program module. Here, you'll learn how to:

Define a module
Create a procedure that performs a task
Call a sub-procedure from within a procedure
Write a function that returns a value
Pass variables to functions and procedures

Understanding Objects with VBA

This section of the MS Access VBA training explores the power of VBA as an object-oriented programming language. Within Access VBA, database components, like forms, queries, tables and reports, are represented as objects that encapsulate specific functionality. We train you how to:

Browse the objects in Access 2007
Respond to an event, such as when a user clicks a button
Store a list of items in a collection
Create an Application object that represents your Access program
Invoke the Form object to present a record
Run a SQL query

Working with Recordsets in VBA

The key to working with database data in Access 2007 is a recordset. Any time you create a form, report, data sheet, or other object, you populate its data using a recordset object. In this pivotal training session you will learn how to:

Create a new recordset
Connect to your database and associate it with your recordset
Query the database and fill your recordset with the results
Place cursors and bookmarks to fields in your database
Filter the results for a recordset
Sort your recordset based on a field

Debugging Code in Access VBA

In this section of the Access VBA training course, you'll find out how to save hours of time and frustration in debugging your code. We'll show you how to prevent bugs from sneaking into your code in the first place, and how to track down elusive bugs if they do appear. The programming environment in Access 2007 includes a full-featured VBA debugger that allows you to set breakpoints at critical spots in your code and stop program execution, step through your code line-by-line, and examine values. We'll teach you how to:

Look for the conditions that cause errors
Understand the difference between syntax, runtime, and logic errors
Set breakpoints where your program will halt so you can examine the code at that point
Step through code and examine values
Step into or over a function or procedure
Examine the Call Stack to see how you arrived at your breakpoint

Handling Errors with Access VBA

There is nothing worse than working with a complex database, only to have your application crash and lose your changes. As in any program, error conditions can happen in unforeseen situations, such as when a user tries to save a file when the disk is full. You'll want to master Access VBA techniques that allow you to handle these error conditions gracefully. After completing this part of the Access training, you'll have the skills to:

Write your own error-handling routines
Trap a known error event and invoke an error-handling procedure to manage it
Catch an error event for which there is no handling routine, and display a message
Use VBA's Err object to discover the conditions that caused the error
Resume execution or exit gracefully after an error has occurred

Prerequisites:

Working experience with Microsoft Access.
Prior programming experience helpful but not required.

Access VBA offered at four locations::

Access 2007 VBA Training