Deck 10: Analyzing Data With Business Intelligence Tools

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

To close a macro,you click the Run button.

Question 5

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

Question 6

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

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

Question 7

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

Question 8

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

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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 13

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 14

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

Question 15

You must specify arguments for each action in a macro.

Question 16

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

Question 17

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

Question 18

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 19

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

Question 20

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 21

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

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

Question 22

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

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

Question 23

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 24

_____ change depending on the macro action you choose.

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

Question 25

OpenReport is an Access macro _____.

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

Question 26

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

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

Question 27

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

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

Question 28

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 29

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 30

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 31

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 32

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

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

Question 33

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 34

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

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

Question 35

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 36

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 37

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

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

Question 38

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 39

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 40

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

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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 45

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 46

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 47

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

Question 48

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

Question 49

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

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

Question 50

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 51

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 52

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

Question 53

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

Question 54

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

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

Question 55

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

Question 56

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 57

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

Question 58

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 59

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 60

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