2 days

Course Description

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.

Course 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

You may also be interested in:

SQL Fundamentals

MCSA BI Reporting