Deck 10: Analyzing Data With Business Intelligence Tools

Question 1

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

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

Answer 1

A

Question 2

You must specify arguments for each action in a macro.

Answer 2

False

Question 3

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

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

Answer 3

C

Question 4

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.

Question 5

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

Question 6

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

Question 7

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.

Question 8

To close a macro, you click the Run button.

Question 9

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

Question 10

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

Question 11

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

Question 12

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

A) Expand All button
B) Run button
C) Debug button
D) View button

Question 13

A common way to run a macro is to assign it to a command button.

Question 14

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

Question 15

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

Question 16

The Caution action displays a warning or informational message.

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

When you single step a macro, you _____.

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 23

_____ change depending on the macro action you choose.

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

Question 24

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

A) events
B) conditions
C) actions
D) queries

Question 25

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

A) Single Step
B) Run
C) Expand All
D) Trigger

Question 26

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

A) procedure
B) conditional expression
C) event
D) Else clause

Question 27

In a macro, arguments provide _____.

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 28

OpenReport is an Access macro _____.

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

Question 29

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

A) modify
B) rename
C) program
D) debug

Question 30

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

A) Comments
B) Arguments
C) Events
D) Conditions

Question 31

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

A) Title
B) On Click
C) View
D) Report Name

Question 32

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

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

Question 33

If you want a macro to display a message after opening a form, where should you insert the MessageBox 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 34

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

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

Question 35

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

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

Question 36

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

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

Question 37

What can you do to hide the actions in a 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 38

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

A) action
B) argument
C) property
D) flow

Question 39

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

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

Question 40

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

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

Question 41

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

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.

Question 42

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

Question 43

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

Question 44

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

A) Code
B) Design
C) SQL
D) Layout

Question 45

How do you create a macro in Access?

A) Use the Macro Wizard to select a task to perform.
B) Use the macro recorder to record your actions as you complete a task.
C) In Macro Design View, add actions and arguments that perform a task.
D) Use the single step recorder to record your actions as you complete a task.

Question 46

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.

A) inner
B) outer
C) self
D) referential

Question 47

The tabs in a Navigation form must match the names of the objects they contain.

Question 48

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

A) Double-click an action in the Action Catalog.
B) Click the Add New Action arrow.
C) Click the appropriate action button on the Macro Tools Design tab.
D) Drag an action from the Action Catalog.

Question 49

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

Question 50

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

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

Question 51

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

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 52

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

Question 53

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

A) another record in the same table
B) an identical record in another table
C) a matching record in another database
D) a record with one or more blank field values

Question 54

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

Question 55

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

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 56

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

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

Question 57

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

A) SaveRecord
B) OpenForm
C) DeleteRecord
D) CloseDesignView

Question 58

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

Question 59

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

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

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

Question 64

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

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