O'Reilly logo

Access 2013: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Automating Tasks with Macros

The secret to a long and happy relationship with Access is learning how to make it work the way you want. As you’ve already seen, true Access fanatics don’t use the ordinary datasheet to enter information. Instead, they create their own customized data entry forms. Similarly, Access fans don’t print their data by using basic yawn-inspiring tables. Instead, they create richly formatted reports that are just right for presenting their data. And Access pros definitely don’t struggle through the same tedious series of steps to accomplish a common task—instead, they create macros that make Access do the work for them.

A macro is a miniature program that you create and store in your database. Macros can range from the exceedingly simple (like a command that shows a form) to the mind-bendingly complex (like a conditional macro that checks how much raw meat you have in stock, and automatically prints an order in triplicate if your fridge is empty).

In this chapter, you’ll learn how to create basic macros. Then, you’ll learn how to make them smarter. By the end of the next chapter, you’ll have completed your macro exploration, and you’ll be able to put together macros that can fire themselves up when needed, perform an entire sequence of steps, and even make decisions.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required