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.
Note, several weeks of practical application is highly recommended.
No programming experience is required.
Introduction to Programming in Access
Working with Procedures and Functions
Using Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Working with Recordsets
Working with Inline Error Handling