Access 2019: Macros

1h 10mIntermediate2018-11-08

Authors

Adam Wilbert

Data Visualization Expert

Course details

Macros are a great tool for developers who want to add functionality and interactivity to Access databases, without writing any additional code. With macros, you can take a list of time-consuming processes, such as launching a series of reports at startup, and run them automatically. This course covers how to build macros from the Access Actions catalog, adjust the execution and flow of macros with conditional logic and variables, and string together actions in multi-step sequences. Instructor Adam Wilbert also dives into macro security and show how to debug macros, gracefully handle noncritical errors, and leverage data macros to perform actions—such as logging and validation—when table data is changed.

Learning objectives
Creating multi-step macros
Triggering macros
Running macros at startup
Adjusting the execution and flow of macros
Troubleshooting macros

Skills covered

Microsoft AccessDesktop DatabasesMicrosoft OfficeComputer SkillsOffice 365Business Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

Introduction

Add functionality and interactivity to Access databases with macros
Follow along and practice

Macro Basics

Why use macros
The macro action catalog
Create a multistep macro
Trigger macros
Embedded macros
Automatically run a macro at startup

Execution and Flow

Organize routines with submacros
Trigger submacros with buttons
If-then conditional macros
Use temporary variables
Pull input variables from forms

Macro Development

Macros and security
Debug macros
Error handling
Data macros and table events

Conclusion

Next steps