Question 1

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 A

Question 2

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  True

Question 3

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 4

Arguments provide ____.

Accepted Answer

A)  Conditional expressions that evaluate to true or false 
B)  Additional information on how to carry out an action 
C)  A way to store many macros together in a group 
D)  A list of events that are associated with each control on a form 
A)  Conditional expressions that evaluate to true or false 
B)  Additional information on how to carry out an action 
C)  A way to store many macros together in a group 
D)  A list of events that are associated with each control on a form

Question 5

Conditional expressions result in a numeric value. _____

Accepted Answer

A) True 
 B)False

Question 6

If statements  may contain Else If and Else clauses.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of a macro.

Accepted Answer

A)  Action 
B)  Event 
C)  Argument 
D)  Submacro 
A)  Action 
B)  Event 
C)  Argument 
D)  Submacro

Question 8

On Click is an example of a(n) ____.

Accepted Answer

A)  Event property 
B)  Bound control 
C)  Command Button Wizard option 
D)  Macro action 
A)  Event property 
B)  Bound control 
C)  Command Button Wizard option 
D)  Macro action

Question 9

A(n) _____ database allows you to run macros and VBA.

Accepted Answer

The answer of A(n) _____ database allows you to run...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

OpenReport is an Access macro ____.

Accepted Answer

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

Question 12

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

Accepted Answer

A)  Actions 
B)  Arguments 
C)  Events 
D)  None of the above 
A)  Actions 
B)  Arguments 
C)  Events 
D)  None of the above

Question 13

Arguments change depending upon the action chosen.

Accepted Answer

A) True 
 B)False

Question 14

In Access macros, conditional expressions are used in If statements.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

Which argument of the MessageBox macro action determines the text in the Title Bar of 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 18

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

Question 19

A conditional expression determines whether a macro action will execute or not.

Accepted Answer

A) True 
 B)False

Question 20

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

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

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

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.

Arguments provide ____.

Conditional expressions result in a numeric value. _____

If statements may contain Else If and Else clauses.

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of a macro.

On Click is an example of a(n) ____.

A(n) _____ database allows you to run macros and VBA.

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

OpenReport is an Access macro ____.

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

Arguments change depending upon the action chosen.

In Access macros, conditional expressions are used in If statements.

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

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

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

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

A conditional expression determines whether a macro action will execute or not.

Which of the following would not constitute an event?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 12: Creating Macros

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

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

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.

Arguments provide ____.

Conditional expressions result in a numeric value. _____

If statements may contain Else If and Else clauses.

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of a macro.

On Click is an example of a(n) ____.

A(n) _____ database allows you to run macros and VBA.

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

OpenReport is an Access macro ____.

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

Arguments change depending upon the action chosen.

In Access macros, conditional expressions are used in If statements.

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

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

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

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

A conditional expression determines whether a macro action will execute or not.

Which of the following would not constitute an event?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters