Alison Balter’s Mastering Microsoft® Office Access 2007 Development

Chapter 7. What Are Macros, and When Do You Need Them?

IN THIS CHAPTER

• Why This Chapter Is Important
• Learning the Basics of Creating and Running a Macro
• Running an Access Macro
• Modifying an Existing Macro
• Documenting Your Macro: Adding Comments
• Testing a Macro
• Determining When You Should Use Macros and When You Shouldn’t
• Converting a Macro to VBA Code
• Creating an AutoExec Macro
• Using the DoCmd Object
• Practical Examples: Adding an AutoExec Macro to the Time and Billing Application

Why This Chapter Is Important

Although you may not prefer to use macros to develop the routines that control your applications, macros in Access 2007 play a major role in the development process. Available in Microsoft Office Access 2007 are embedded macros. Rather ...