Question 1

A(n)________ is typically a folder on your hard disk or a network share where trusted files are located.

Accepted Answer

The answer of A(n)________ is typically a folder on your...

Question 2

Access allows a macro to be copied from the Macro Designer and pasted into a text editor as ________ to save as a backup or to share with others.

Accepted Answer

The answer of Access allows a macro to be copied...

Question 3

________ can be incorporated into other macros by using the RunMacro or OnError actions but cannot be executed directly from the Navigation Pane.

Accepted Answer

The answer of ________ can be incorporated into other macros...

Question 4

There are five different table events that macros can be associated with: Before Change,Before Delete,After Insert,After Update,and After Delete.

Accepted Answer

This statement is true. Macros can be associated with Before Change, Before Delete, After Insert, After Update, and After Delete events within a table.

Question 5

Certain data actions are available for all table events.

Accepted Answer

Not all data actions are available for every table event; availability depends on the specific event and the database system's capabilities.

Question 6

An AutoExec macro can be bypassed by holding down the Ctrl key when opening the database.

Accepted Answer

The answer of An AutoExec macro can be bypassed by...

Question 7

Actions can be moved around by ________ them to the desired location.

Accepted Answer

The answer of Actions can be moved around by ________...

Question 8

A(n)________ is a form of internal documentation that can help explain the purpose of a macro.

Accepted Answer

The answer of A(n)________ is a form of internal documentation...

Question 9

________ are database objects that provide a method of automating routine database tasks.

Accepted Answer

The answer of ________ are database objects that provide a...

Question 10

As you point to each action group and action,Access displays a(n)________ that explains the general purpose of the object.

Accepted Answer

The answer of As you point to each action group...

Question 11

The ________ contains a list of blocks that can control the order that actions are executed or help structure the macro.

Accepted Answer

The answer of The ________ contains a list of blocks...

Question 12

________ macros can be executed directly from the Navigation Pane by double-clicking the macro object,clicking Run in Design view,or by attaching the macro to a database object,like a button or text field.

Accepted Answer

The answer of ________ macros can be executed directly from...

Question 13

The ________ is an interface for building and editing macros.

Accepted Answer

The answer of The ________ is an interface for building...

Question 14

Before events occur before any changes are made to the table data,and After events occur after the changes have been successfully made.

Accepted Answer

This is correct. Before events occur before any changes are made to the table data, and After events occur after the changes have been successfully made.

Question 15

If you want a set of actions to run every time a database is opened,then you can create an AutoKeys macro.

Accepted Answer

An AutoKeys macro is used to assign keyboard shortcuts to actions, not to run actions when a database is opened. To run actions upon opening a database, you would use an AutoExec macro.

Question 16

________ macros are stored in Access tables and are triggered by table events and are typically used to implement business logic into tables and automatically set values in fields.

Accepted Answer

The answer of ________ macros are stored in Access tables...

Question 17

________ macros are stored as part of a database object such as a form or report or any control like a button.

Accepted Answer

The answer of ________ macros are stored as part of...

Question 18

________ macros have been known to add,edit,or remove data from a database and often spread to other databases or even to the user's computer.

Accepted Answer

The answer of ________ macros have been known to add,edit,or...

Question 19

A(n)________ is a self-contained instruction that can be combined with other instructions to automate tasks and is considered to be the basic building block of macros.

Accepted Answer

The answer of A(n)________ is a self-contained instruction that can...

Question 20

The ________ is a searchable set of macro actions that can retrieve actions based on keywords.

Accepted Answer

The answer of The ________ is a searchable set of...

Quiz 12: Workshop 12: Create a Refined User Experience With Macros