Question 1

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 2

____ is a major benefit of using macros.

Accepted Answer

A)  Saving paper 
B)  Improving accuracy 
C)  Eliminating forms and reports 
D)  Redesigning the database 
A)  Saving paper 
B)  Improving accuracy 
C)  Eliminating forms and reports 
D)  Redesigning the database

Question 3

An entry in a field can be used to initiate the execution of a macro.

Accepted Answer

A) True 
 B)False

Question 4

A conditional expression is an expression that results in a true or false value.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT a common macro action?

Accepted Answer

A)  DeleteRecord 
B)  SaveRecord 
C)  OpenForm 
D)  CloseDesignView 
A)  DeleteRecord 
B)  SaveRecord 
C)  OpenForm 
D)  CloseDesignView

Question 6

All Access events are triggered by the user.

Accepted Answer

A) True 
 B)False

Question 7

You can print Macro Design View.

Accepted Answer

A) True 
 B)False

Question 8

As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Accepted Answer

A) True 
 B)False

Question 9

Arguments change depending upon the action chosen.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

The answer of The action _____ organizes all of the...

Question 12

Which argument of the MessageBox macro action determines the icon 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 13

In the figure above, what type of object is referenced in the conditional expression?

Accepted Answer

A)  Form 
B)  Report 
C)  Macro 
D)  Module 
A)  Form 
B)  Report 
C)  Macro 
D)  Module

Question 14

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

Accepted Answer

A) True 
 B)False

Question 15

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,...

Question 16

Name three ways that you can run a macro.

Accepted Answer

1.  By clicking the Run button in Macro

Question 17

As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

Accepted Answer

The answer of   As shown in the figure,...

Question 18

Which of the following would not constitute an event?

Accepted Answer

A)  Adding an action to a macro 
B)  Clicking a command button 
C)  Opening a form 
D)  Closing a form 
A)  Adding an action to a macro 
B)  Clicking a command button 
C)  Opening a form 
D)  Closing a form

Question 19

Which of the following tasks is a good candidate for a macro?

Accepted Answer

A)  Printing several reports 
B)  Modifying the design of a form 
C)  Building ad hoc reports 
D)  Creating graphs 
A)  Printing several reports 
B)  Modifying the design of a form 
C)  Building ad hoc reports 
D)  Creating graphs

Question 20

An action block can be expanded or collapsed to view or hide details in Macro Design View.

Accepted Answer

A) True 
 B)False

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

____ is a major benefit of using macros.

An entry in a field can be used to initiate the execution of a macro.

A conditional expression is an expression that results in a true or false value.

Which of the following is NOT a common macro action?

All Access events are triggered by the user.

You can print Macro Design View.

As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Arguments change depending upon the action chosen.

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

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 MessageBox macro action determines the icon in the dialog box that is created?

In the figure above, what type of object is referenced in the conditional expression?

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

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.

Name three ways that you can run a macro.

As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

Which of the following would not constitute an event?

Which of the following tasks is a good candidate for a macro?

An action block can be expanded or collapsed to view or hide details in Macro Design View.

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 13: Creating Macros

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

____ is a major benefit of using macros.

An entry in a field can be used to initiate the execution of a macro.

A conditional expression is an expression that results in a true or false value.

Which of the following is NOT a common macro action?

All Access events are triggered by the user.

You can print Macro Design View.

As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Arguments change depending upon the action chosen.

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

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 MessageBox macro action determines the icon in the dialog box that is created?

In the figure above, what type of object is referenced in the conditional expression?

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

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.

Name three ways that you can run a macro.

As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

Which of the following would not constitute an event?

Which of the following tasks is a good candidate for a macro?

An action block can be expanded or collapsed to view or hide details in Macro Design View.

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters