Exam 10: Analyzing Data With Business Intelligence Tools

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

You must specify arguments for each action in a macro.

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

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

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

OpenReport is an Access macro _____.

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.

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

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

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

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

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

How do you create a macro in Access?

The purpose of a Navigation form is to let users navigate easily among the forms and reports in the database.

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

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.

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

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

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

A macro may contain one or more _____,the tasks that you want Access to perform.