Access 2019: Macros

Learn how to create macros to automate tasks and processes in Microsoft Access 2019.

Introduction

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

1. Macro Basics

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

2. Execution and Flow

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

3. Macro Development

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

Conclusion

• Next steps