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…and is sometimes overkill for many common tasks.…Further, using VBA code in your database projects…
Author
Adam Wilbert
Released
11/8/2018- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros
Skill Level Intermediate
Duration
Views
-
Introduction
-
Follow along and practice1m 33s
-
1. Macro Basics
-
Why use macros?3m 18s
-
The macro action catalog5m 46s
-
Create a multistep macro5m 19s
-
Trigger macros4m 23s
-
Embedded macros2m 48s
-
-
2. Execution and Flow
-
If-then conditional macros3m 16s
-
Use temporary variables6m 45s
-
3. Macro Development
-
Macros and security3m 38s
-
Debug macros4m 45s
-
Error handling6m 51s
-
Data macros and table events6m 35s
-
-
Conclusion
-
Next steps22s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Why use macros?