Question 1

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

Accepted Answer

A) True 
 B)False  False

Question 2

The action _____ organizes all of the arguments for a current action and is visually highlighted with a rectangle and gray background in Macro Design View.

Accepted Answer

block

Question 3

Which argument of the OpenReport macro action determines the report that is opened?

Accepted Answer

A)  Report Name 
B)  Title 
C)  View 
D)  On Click 
A)  Report Name 
B)  Title 
C)  View 
D)  On Click A

Question 4

Defragging means determining why a macro doesn't run correctly.

Accepted Answer

A) True 
 B)False

Question 5

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

Accepted Answer

A) True 
 B)False

Question 6

____ is a useful Access macro action because it opens a report.

Accepted Answer

The answer of ____ is a useful Access macro action...

Question 7

-In the figure above, how many macro actions are shown?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 8

OpenReport is an Access macro ____.

Accepted Answer

A)  Action 
B)  Event 
C)  Condition 
D)  Group 
A)  Action 
B)  Event 
C)  Condition 
D)  Group

Question 9

Match the Macro Design View component with its description.
-Lists required and optional arguments for the selected action

Accepted Answer

A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button 
A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button

Question 10

To permanently trust a database, store the database in a trusted folder.

Accepted Answer

A) True 
 B)False

Question 11

You most often run a data macro based on a table event.

Accepted Answer

A) True 
 B)False

Question 12

Match the Macro Design View component with its description.
-Lists all of the macro actions organized by category

Accepted Answer

A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button 
A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button

Question 13

The _____ Catalog lists all available macro actions organized by category.

Accepted Answer

The answer of The _____ Catalog lists all available macro...

Question 14

-In the figure above, how many arguments are shown for the current action?

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 15

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

Accepted Answer

A)  Message 
B)  View 
C)  Type 
D)  Title 
A)  Message 
B)  View 
C)  Type 
D)  Title

Question 16

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

Accepted Answer

A data macro is managed directly from wi

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

You can print Macro Design View.

Accepted Answer

A) True 
 B)False

Question 19

You are a busy information technology (IT) specialist at a well-known accounting firm. You work with departments throughout the company to help them solve problems and simplify computer tasks.
-One of your coworkers asks you to explain the difference between Excel and Access with regard to creating macros and VBA. What do you tell him?

Accepted Answer

When you create a macro in Exc

Question 20

-As shown in the figure, a(n) _____ statement contains conditional expressions that are evaluated either true or false that determine whether the macro action is executed or skipped.

Accepted Answer

The answer of  
-As shown in the figure, a(n)...

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

The action _____ organizes all of the arguments for a current action and is visually highlighted with a rectangle and gray background in Macro Design View.

Which argument of the OpenReport macro action determines the report that is opened?

Defragging means determining why a macro doesn't run correctly.

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

____ is a useful Access macro action because it opens a report.

-In the figure above, how many macro actions are shown?

OpenReport is an Access macro ____.

Match the Macro Design View component with its description. -Lists required and optional arguments for the selected action

To permanently trust a database, store the database in a trusted folder.

You most often run a data macro based on a table event.

Match the Macro Design View component with its description. -Lists all of the macro actions organized by category

The _____ Catalog lists all available macro actions organized by category.

-In the figure above, how many arguments are shown for the current action?

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

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

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

You can print Macro Design View.

-As shown in the figure, a(n) _____ statement contains conditional expressions that are evaluated either true or false that determine whether the macro action is executed or skipped.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 14: Creating Macros

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

The action _____ organizes all of the arguments for a current action and is visually highlighted with a rectangle and gray background in Macro Design View.

Which argument of the OpenReport macro action determines the report that is opened?

Defragging means determining why a macro doesn't run correctly.

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

____ is a useful Access macro action because it opens a report.

-In the figure above, how many macro actions are shown?

OpenReport is an Access macro ____.

Match the Macro Design View component with its description. -Lists required and optional arguments for the selected action

To permanently trust a database, store the database in a trusted folder.

You most often run a data macro based on a table event.

Match the Macro Design View component with its description. -Lists all of the macro actions organized by category

The _____ Catalog lists all available macro actions organized by category.

-In the figure above, how many arguments are shown for the current action?

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

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

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

You can print Macro Design View.

-As shown in the figure, a(n) _____ statement contains conditional expressions that are evaluated either true or false that determine whether the macro action is executed or skipped.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters