Exam 13: Creating Macros

After choosing the macro action you want, you then decide which arguments you want to apply to the action and whether each argument should be required or optional.

Conditional expressions result in a numeric value. _____

A(n) ____ is a collection of actions within a macro object that allows you to name and create multiple, separate macros within a single macro object.

The click of a command button or making an entry in a field would be considered a(n) ____.

A table macro allows you to embed macro capabilities directly in a table.

Each macro task has a specified set of ____ that provide additional information on how to carry out the task.

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

A secure database allows you to run macros and VBA.

In the figure above, what is the name of the first action?

Which argument of the MessageBox macro action determines the text in the dialog box that is created?

You can assign a command button to a macro using the Command Button Wizard.

Which of the following is NOT an argument for the SetProperty action?

By default, an Access database is trusted.

In a macro, to refer to a value of a control on a form in a conditional expression, use the following syntax: ____.

Data macros appear in the Macros group in the Navigation Pane.

Some arguments of a macro action are optional.

In the figure above, what is the macro action that is currently being evaluated?

Fixing a broken macro generally involves breaking it down into smaller pieces that can be individually tested.

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

The event property that is most commonly used with a command button is the _____ property.