Course Length: 2-days

Course Overview

Microsoft describes Access as a complete relational database management system that offers powerful tools of creating tables, queries, forms and reports. Access also includes another important tool: Visual Basic for Applications – an easy to learn yet full featured programming language that will take your database design beyond the normal. With VBA you will learn to write code that lets your forms and reports respond to events triggered by user database interactions. With VBA you can programmatically access the data in tables for purposes of accessing, archiving or migrating data.

Prerequisites

Access Part 1

Access Part 2

Note: several weeks of practical application is highly recommended.

No programming experience is required.

Outline

  • Introduction to Programming in Access
  • Working with Procedures and Functions
  • Understanding Objects
  • Using Expressions, Variables, and Intrinsic Functions
  • Controlling Program Execution
  • Working with Recordsets
  • Debugging Code
  • Handling Errors
  • Working with Inline Error Handling