Deck 14: Creating Macros

Question 1

A conditional expression determines whether a macro action will execute or not.

Answer 1

True

Question 2

You can print Macro Design View.

Answer 2

True

Question 3

If statements in Access 2013 may contain Else If and Else clauses.

Answer 3

True

Question 4

Which of the following is NOT a benefit of using macros?

A) Decreases the number of objects required in the database
B) Increases efficiency by automating routine tasks
C) Increases accuracy by flagging data entry errors
D) Improves flexibility by connecting forms and reports together through command buttons

Question 5

An entry in a field can be used to initiate the execution of a macro.

Question 6

Fixing a broken macro generally involves breaking it down into smaller pieces that can be individually tested.

Question 7

Data macros appear in the Macros group in the Navigation Pane.

Question 8

Some arguments of a macro action are optional.

Question 9

An action block can be expanded or collapsed to view or hide details in Macro Design View.

Question 10

It's common to put command buttons in the Form Footer so that users have a consistent location to find them.

Question 11

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

A) Printing several reports
B) Modifying the design of a form
C) Building ad hoc reports
D) Creating graphs

Question 12

You cannot override existing Access key combinations such as [Ctrl][C] for copy with an Access AutoKey assignment.

Question 13

By default, an Access database is trusted.

Question 14

After choosing the macro action you want, you then decide which arguments you want to apply to the action and whether each argument should be required or optional.

Question 15

You can assign a command button to a macro using the Command Button Wizard.

Question 16

You can assign a macro to a command button using the Command Button Wizard.

Question 17

In Access macros, conditional expressions are used in If statements.

Question 18

Macro actions are evaluated based on their order in the Macro Design View window, starting at the bottom.

Question 19

All Access events are triggered by the user.

Question 20

Arguments change depending upon the action chosen.

Question 21

In the figure above, which argument does NOT require a value?

A) Report Name
B) View
C) Filter Name
D) Window Mode

Question 22

In the figure above, the expression for the If statement is written in ____.

A) Access syntax
B) Dot notation
C) Bang notation
D) None of the above

Question 23

In the figure above, how many macro actions are shown?

A) 1
B) 2
C) 3
D) 4

Question 24

A(n) ____ is something that happens to a form, window, toolbar, or control that can be used to initiate the execution of a macro.

A) Action
B) Event
C) Argument
D) Submacro

Question 25

Each macro task has a specified set of ____ that provide additional information on how to carry out the task.

A) Actions
B) Arguments
C) Events
D) None of the above

Question 26

In the figure above, what is the name of the first action?

A) OpenReport
B) Macro1
C) Window Mode
D) MessageBox

Question 27

A(n) ____ expression results in a true or false answer.

A) Action
B) Conditional
C) Group
D) Mathematical

Question 28

Which of the following is NOT a common macro action?

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

Question 29

OpenReport is an Access macro ____.

A) Action
B) Event
C) Condition
D) Group

Question 30

The best way to make a macro obviously available for many different forms would be to ____.

A) Click the Run button from the DATABASE TOOLS tab
B) Run the macro from Macro Design View
C) Assign the macro to a command button on the first form the user opens
D) Assign the macro to the Ribbon

Question 31

In the figure above, what type of object is referenced in the conditional expression?

A) Form
B) Report
C) Macro
D) Module

Question 32

____ is a major benefit of using macros.

A) Saving paper
B) Improving accuracy
C) Eliminating forms and reports
D) Redesigning the database

Question 33

Which of the following would not constitute an event?

A) Adding an action to a macro
B) Clicking a command button
C) Opening a form
D) Closing a form

Question 34

In a macro, to refer to a value of a control on a form in a conditional expression, use the following syntax: ____.

A) {Forms}!{formname}!{controlname}
B) [Forms]![formname]![controlname]
C) Forms.(formname).(controlname)
D) Forms.formname(controlname)

Question 35

Which of the following is NOT an argument for OpenReport?

A) Report Name
B) Default Ribbon
C) View
D) Window Mode

Question 36

ApplyFilter, RunCommand, Close, and OpenReport are examples of macro ____.

A) Actions
B) Arguments
C) Groups
D) Conditions

Question 37

On Click is an example of a(n) ____.

A) Event property
B) Bound control
C) Command Button Wizard option
D) Macro action

Question 38

Arguments provide ____.

A) Conditional expressions that evaluate to true or false
B) Additional information on how to carry out an action
C) A way to store many macros together in a group
D) A list of events that are associated with each control on a form

Question 39

In the figure above, how many arguments are shown for the current action?

A) 3
B) 4
C) 5
D) 6

Question 40

A(n) ____ is a collection of actions within a macro object that allows you to name and create multiple, separate macros within a single macro object.

A) Action
B) Event
C) Argument
D) Submacro

Question 41

A(n) _____ is a database object that stores and executes a series of Access actions.

Question 42

Which of the following is NOT an argument for the SetProperty action?

A) View
B) Control Name
C) Property
D) Value

Question 43

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

Question 44

In the figure above, what is the name of the macro that is being single stepped?

A) PreviewAllEquipmentReport
B) PreviewReportsMacroGroup
C) MsgBox
D) OpenReport

Question 45

The _____ Catalog lists all available macro actions organized by category.

Question 46

In the figure above, what is the macro action that is currently being evaluated?

A) PreviewReports
B) Macro Group
C) True
D) OpenReport

Question 47

A common three-character prefix for command buttons is _____.

A) com
B) mmm
C) cmd
D) btt

Question 48

The action _____ organizes all of the arguments for a current action and is visually highlighted with a rectangle and gray background in Macro Design View.

Question 49

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

A) exclamation
B) conditional
C) macro
D) bang

Question 50

Which argument of the MessageBox macro action determines the text in the dialog box that is created?

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

Question 51

____ is a useful Access macro action because it opens a report.

Question 52

As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

Question 53

Which argument of the MessageBox macro action determines the icon in the dialog box that is created?

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

Question 54

Which of the following is NOT a valid table event for a data macro?

A) After Got Focus
B) After Insert
C) After Update
D) Before Delete

Question 55

The event property that is most commonly used with a command button is the _____ property.

A) Push
B) Hover
C) Select
D) On Click

Question 56

Which argument of the OpenReport macro action determines the report that is opened?

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

Question 57

Which argument of the MessageBox macro action determines the text in the Title Bar of the dialog box that is created?

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

Question 58

The click of a command button or making an entry in a field would be considered a(n) ____.

A) Macro
B) Action
C) Condition
D) Event

Question 59

The _____ button executes the selected Access macro.

Question 60

In the Macro Single Step dialog box in the figure, which button would you click to run the next macro action?

A) Step
B) Halt
C) Next
D) Run

Question 61

List four of the major benefits of using macros.

Question 62

A(n) _____ database allows you to run macros and VBA.

Question 63

A secure database allows you to run macros and VBA.

Question 64

To permanently trust a database, store the database in a trusted _____.

Question 65

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

Question 66

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

Question 67

Conditional expressions result in a numeric value. _____

Question 68

As shown in the figure, a(n) _____ statement contains conditional expressions that are evaluated either true or false that determine whether the macro action is executed or skipped.

Question 69

As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Question 70

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

Question 71

Explain the difference between a data macro and a traditional macro object in terms of how the macro is created, stored, and triggered.

Question 72

A table macro allows you to embed macro capabilities directly in a table.

Question 73

As shown in the figure, a(n) _____ expression results in either a true or false answer.

Question 74

You can slow step a macro, which means to run it one action at a time to observe the effect of each specific action.

Question 75

Name three ways that you can run a macro.

Question 76

Defragging means determining why a macro doesn't run correctly.

Question 77

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

Question 78

You most often run a data macro based on a table event.

Question 79

As shown in the figure, Message, Beep, Type, and Title are arguments for the MessageBox macro action.

Question 80

The On _____ event occurs when focus moves from one record to another.