Microsoft® Access® 2010 Inside Out

Making Your Application Come Alive with Macros

Throughout this book, you’ve learned how to perform common tasks by using ribbon commands or by finding the object you want in the Navigation pane and opening it. In working with your database, you’ve probably also noticed that you perform certain tasks repeatedly or on a regular basis. You can automate these tasks by creating macros to execute the actions you perform and then associating the macros with various form or control events, such as the Current event of a form, the Click event of a command button, or the DblClick event of a text box. In the following sections, you’ll use examples from the Wedding List Macro sample database (WeddingMC.accdb) to understand how macros can help automate your ...