Question 1

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

Accepted Answer

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

Question 2

In which of the following situations would you create a query with a self join?

Accepted Answer

A)  You want to identify orders with no customer address. 
B)  You want to list managers and their employees. 
C)  You want to list all products in the "Electronics" category. 
D)  You want to increase Fee field values by $25.00. 
A)  You want to identify orders with no customer address. 
B)  You want to list managers and their employees. 
C)  You want to list all products in the "Electronics" category. 
D)  You want to increase Fee field values by $25.00. B

Question 3

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

Accepted Answer

A) True 
 B)False  False

Question 4

You can assign a key combination to a macro by creating a macro with the name _____.

Accepted Answer

A)  AutoKeys 
B)  Macro1 
C)  KeyCombo 
D)  CTRL+K 
A)  AutoKeys 
B)  Macro1 
C)  KeyCombo 
D)  CTRL+K

Question 5

In a macro, a Group component lets you sort macro arguments.

Accepted Answer

A) True 
 B)False

Question 6

What can you do to hide the actions in a macro?

Accepted Answer

A)  Collapse all the actions in the macro. 
B)  Single step through the macro. 
C)  Set the macro's Visible property to No. 
D)  Add a Group program flow to the macro. 
A)  Collapse all the actions in the macro. 
B)  Single step through the macro. 
C)  Set the macro's Visible property to No. 
D)  Add a Group program flow to the macro.

Question 7

When you add actions to a Group program flow, the macro does not perform the actions.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  Modifying the design of a form 
B)  Printing several reports 
C)  Creating a report 
D)  Adding a chart to a tab control 
A)  Modifying the design of a form 
B)  Printing several reports 
C)  Creating a report 
D)  Adding a chart to a tab control

Question 9

The _____ organizes all the arguments for an action in a rectangle with a gray background.

Accepted Answer

A)  update block 
B)  Macro Single Step dialog box 
C)  action block 
D)  event procedure 
A)  update block 
B)  Macro Single Step dialog box 
C)  action block 
D)  event procedure

Question 10

_____ change depending on the macro action you choose.

Accepted Answer

A)  Events 
B)  Arguments 
C)  Expressions 
D)  Properties 
A)  Events 
B)  Arguments 
C)  Expressions 
D)  Properties

Question 11

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

Accepted Answer

A)  As the first action in the macro 
B)  After the OpenForm action 
C)  As the last action in the macro 
D)  Before the OpenForm action 
A)  As the first action in the macro 
B)  After the OpenForm action 
C)  As the last action in the macro 
D)  Before the OpenForm action

Question 12

The Action Catalog lists all of the macro actions organized by category.

Accepted Answer

A) True 
 B)False

Question 13

To expand an action in a macro, click the action name in the Action Catalog.

Accepted Answer

A) True 
 B)False

Question 14

To add a report to a Navigation form, change the report's Display property to Navigation.
​

Accepted Answer

A) True 
 B)False

Question 15

A(n) _____ join relates a record of a table to another record in the same table.

Accepted Answer

A)  duplicate 
B)  alias 
C)  self 
D)  union 
A)  duplicate 
B)  alias 
C)  self 
D)  union

Question 16

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

Accepted Answer

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

Question 17

Which of the following are benefits of using macros? Select all the options that apply.

Accepted Answer

A)  They can increase accuracy by flagging data entry errors. 
B)  They can increase accuracy by flagging data entry errors 
C)  They decrease the number of objects required in the database. 
D)  They help users by responding to their interactions within a form. 
A)  They can increase accuracy by flagging data entry errors. 
B)  They can increase accuracy by flagging data entry errors 
C)  They decrease the number of objects required in the database. 
D)  They help users by responding to their interactions within a form.

Question 18

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

Accepted Answer

A) True 
 B)False

Question 19

When you single step a macro, you _____.

Accepted Answer

A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument 
A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument

Question 20

Vertical Tabs, Left is one of the _____ you can select for a Navigation form.

Accepted Answer

A)  navigation system styles 
B)  startup options 
C)  form dependencies 
D)  database objects 
A)  navigation system styles 
B)  startup options 
C)  form dependencies 
D)  database objects

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

In which of the following situations would you create a query with a self join?

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

You can assign a key combination to a macro by creating a macro with the name _____.

In a macro, a Group component lets you sort macro arguments.

What can you do to hide the actions in a macro?

When you add actions to a Group program flow, the macro does not perform the actions.

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

The _____ organizes all the arguments for an action in a rectangle with a gray background.

_____ change depending on the macro action you choose.

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

The Action Catalog lists all of the macro actions organized by category.

To expand an action in a macro, click the action name in the Action Catalog.

To add a report to a Navigation form, change the report's Display property to Navigation.

A(n) _____ join relates a record of a table to another record in the same table.

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

Which of the following are benefits of using macros? Select all the options that apply.

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

When you single step a macro, you _____.

Vertical Tabs, Left is one of the _____ you can select for 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

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

In which of the following situations would you create a query with a self join?

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

You can assign a key combination to a macro by creating a macro with the name _____.

In a macro, a Group component lets you sort macro arguments.

What can you do to hide the actions in a macro?

When you add actions to a Group program flow, the macro does not perform the actions.

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

The _____ organizes all the arguments for an action in a rectangle with a gray background.

_____ change depending on the macro action you choose.

If you want a macro to display a message after opening a form, where should you insert the MessageBox action?

The Action Catalog lists all of the macro actions organized by category.

To expand an action in a macro, click the action name in the Action Catalog.

To add a report to a Navigation form, change the report's Display property to Navigation. ​

A(n) _____ join relates a record of a table to another record in the same table.

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

Which of the following are benefits of using macros? Select all the options that apply.

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

When you single step a macro, you _____.

Vertical Tabs, Left is one of the _____ you can select for 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

To add a report to a Navigation form, change the report's Display property to Navigation.