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