Exam 10: Analyzing Data With Business Intelligence Tools

Which of the following are common macro actions? Select all the options that apply.

A(n) _____ is an individual step that a macro performs.

To close a macro, you click the Run button.

When you convert a macro, you break it down, step by step, to observe the effect of each action.

Create a(n) _____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

The part of an If statement that is evaluated as either true or false is called a(n) _____.

A self join relates a record of a table to _____.

You click the _____ button to execute the selected Access macro.

_____ are properties of an action that provide additional information on how the action should execute.

You cannot view a query with a self join in SQL View.

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

How do you create a macro in Access?

Which argument of the OpenReport macro action determines the report to open?

When you click the Collapse button next to a macro action in Macro Design View, you hide the action's arguments.

What do you click to perform the actions in a macro?

A(n) data macro is a collection of actions within a single macro object.

One way to _____ a macro is to single step through the macro.

How can you add an action to a macro? Select all the options that apply.

In Access macros, you can use conditional expressions in If statements.

You can view the SQL code for any query by switching to _____ view.