(800) 716-4324
company catalog schedule discounts register contact

Training Links

Register

Access VBA Training

Microsoft Access, the MS Office suite's desktop database application, is a powerful tool for building and storing complex data. As an advanced Access user, you're probably familiar with designing tables, sorting records, constructing queries, and generating reports. But if your organization needs you to create custom MS Access solutions, you'll want to gain mastery of Visual Basic for Applications (VBA) - as quickly and easily as possible. Our Access VBA training class gives you practice in programming Access's built-in objects and adding logic to create specialized applications that present your users with intuitive, form-based interfaces.

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 programmable objects in Access hierarchy
  • 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 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 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::

Adobe Authorized Training Center Microsoft Certified Partner Google Certified Partner
Newsletter subscribers can win $100 credit! | Privacy Policy | Terms of Use    Social Media Buttons AcademyX on Facebook AcademyX on Google+ AcademyX on LinkedIn AcademyX on Twitter AcademyX on Youtube