Access 2010: Buttons and macros in pdf

You can add buttons to Access data entry forms that, when clicked, perform one or more specified actions. You can create buttons either by using the Button Wizard, though there are limited options using this, or by building a macro and then creating a button that you press to run the macro.

Okay, so the next question is what is a macro? Macros consist of an action, or a list of actions, designed to perform, automatically, one or more tasks, such as opening a form, printing a report or finding a subset of records based on specific criteria.In short, buttons and macros are about automating your database. However, you don’t have to manually press a button to run a specific macro and can instead tell Access when to run a macro based on a specific event, such as tabbing into or out of a field or on entering data that matches specific criteria.

Aims and Learning Objectives

By the end of this course you will be able to: 

• create buttons to automate your database;
• create simple macros;
• create macros that do different things depending on the situation;
• create message boxes using macros