Question 1

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following clauses can an If statement contain in a macro?

Accepted Answer

A)  Otherwise and Never 
B)  Where and When 
C)  Else and Else If 
D)  Do and Until 
A)  Otherwise and Never 
B)  Where and When 
C)  Else and Else If 
D)  Do and Until

Question 3

The Caution action displays a warning or informational message.

Accepted Answer

False 
- MessageBox

Question 4

Which Action Catalog category contains the Comment, Group, If, and Submacro components?

Accepted Answer

A)  Actions 
B)  Conditional Statements 
C)  Messages 
D)  Program Flow 
A)  Actions 
B)  Conditional Statements 
C)  Messages 
D)  Program Flow

Question 5

What property would you use in an If statement to display a label in some records but not others?

Accepted Answer

A)  Visible 
B)  On Current 
C)  Else 
D)  On Display 
A)  Visible 
B)  On Current 
C)  Else 
D)  On Display

Question 6

In Access, you create a macro by recording a series of steps you want the macro to perform.

Accepted Answer

A) True 
 B)False

Question 7

OpenReport is an Access macro _____.

Accepted Answer

A)  event 
B)  condition 
C)  action 
D)  group 
A)  event 
B)  condition 
C)  action 
D)  group

Question 8

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

Accepted Answer

False - st

Question 9

You reference a submacro in a macro list using the command Submacro().

Accepted Answer

A) True 
 B)False

Question 10

What is the first step in creating a query with a self join in Query Design View?

Accepted Answer

A)  Display two field lists for the same table. 
B)  Add the Join Type row to the query design grid. 
C)  Remove all field lists from the upper pane. 
D)  Establish a one-to-many relationship between two tables. 
A)  Display two field lists for the same table. 
B)  Add the Join Type row to the query design grid. 
C)  Remove all field lists from the upper pane. 
D)  Establish a one-to-many relationship between two tables.

Question 11

You must specify arguments for each action in a macro.

Accepted Answer

A) True 
 B)False

Question 12

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

Accepted Answer

A) True 
 B)False

Question 13

When you _____ a macro, you determine why it is not running correctly.

Accepted Answer

A)  debug 
B)  design 
C)  expand 
D)  group 
A)  debug 
B)  design 
C)  expand 
D)  group

Question 14

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

Accepted Answer

A) True 
 B)False

Question 15

Which argument of the MessageBox macro action determines the icon in the message dialog box?

Accepted Answer

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

Question 16

A(n) _____ form is a special Access form that provides an easy-to-use database interface.

Accepted Answer

A)  Navigation 
B)  Split 
C)  Sub 
D)  Startup 
A)  Navigation 
B)  Split 
C)  Sub 
D)  Startup

Question 17

You can collapse all actions in a macro to hide its details.

Accepted Answer

A) True 
 B)False

Question 18

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

Accepted Answer

A)  If statement 
B)  query 
C)  Group program flow 
D)  Run statement 
A)  If statement 
B)  query 
C)  Group program flow 
D)  Run statement

Question 19

In a macro, arguments provide _____.

Accepted Answer

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

Question 20

Drag a form to the [Add New] button to display the form in a Navigation form.

Accepted Answer

A) True 
 B)False

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Which of the following clauses can an If statement contain in a macro?

The Caution action displays a warning or informational message.

Which Action Catalog category contains the Comment, Group, If, and Submacro components?

What property would you use in an If statement to display a label in some records but not others?

In Access, you create a macro by recording a series of steps you want the macro to perform.

OpenReport is an Access macro _____.

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

You reference a submacro in a macro list using the command Submacro().

What is the first step in creating a query with a self join in Query Design View?

You must specify arguments for each action in a macro.

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

When you _____ a macro, you determine why it is not running correctly.

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

Which argument of the MessageBox macro action determines the icon in the message dialog box?

A(n) _____ form is a special Access form that provides an easy-to-use database interface.

You can collapse all actions in a macro to hide its details.

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

In a macro, arguments provide _____.

Drag a form to the [Add New] button to display the form in a Navigation form.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 10: Analyzing Data With Business Intelligence Tools

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Which of the following clauses can an If statement contain in a macro?

The Caution action displays a warning or informational message.

Which Action Catalog category contains the Comment, Group, If, and Submacro components?

What property would you use in an If statement to display a label in some records but not others?

In Access, you create a macro by recording a series of steps you want the macro to perform.

OpenReport is an Access macro _____.

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

You reference a submacro in a macro list using the command Submacro().

What is the first step in creating a query with a self join in Query Design View?

You must specify arguments for each action in a macro.

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

When you _____ a macro, you determine why it is not running correctly.

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

Which argument of the MessageBox macro action determines the icon in the message dialog box?

A(n) _____ form is a special Access form that provides an easy-to-use database interface.

You can collapse all actions in a macro to hide its details.

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

In a macro, arguments provide _____.

Drag a form to the [Add New] button to display the form in a Navigation form.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Exploring Pivottable Design

Developing an Excel Application

Filters