Macros, like tables, queries, forms, and reports, are an important component of an Access database. They help drive interactions in the system, such as navigating between forms or modifying data in a table. Macros differ from Visual Basic code modules in that they won’t typically trigger security warnings in the database and don’t require developers to read or write code.
- [Instructor] Let's start by talking about what macros are … and when you would use one. … Macros are one of the component objects … of an Access database. … Like tables, queries, forms, and reports, … macros serve a specialized role in the system. … They allow database developers to connect objects together … and add functionality and interactivity to the database. … For instance, when a user clicks on a form … that you've designed, … a macro will tell the system what actions to perform … and in what order. … Microsoft Access actually provides database developers … with two control objects that can add functionality … and interactivity to the database. … You can find them both on the Create tab … in the Macros and Code Group. … The first is a code module … and it requires that developers can read and write code … in the Visual Basic programming language. … It's a great flexible choice for seasoned programmers, … but it has a steep learning curve … for people that are new to Access development …
- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros