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
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