Deck 13: Creating Macros

Question 1

By default, an Access database is trusted.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

A

Question 4

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

Question 5

All Access events are triggered by the user.

Question 6

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

Question 7

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

Question 8

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

Question 9

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 10

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

Question 11

You can print Macro Design View.

Question 12

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

Question 13

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

Question 14

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

Question 15

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 16

Arguments change depending upon the action chosen.

Question 17

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

Question 18

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

Question 19

Some arguments of a macro action are optional.

Question 20

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

Question 21

____ is a major benefit of using macros.

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

Question 22

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 23

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

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

Question 24

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 25

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 26

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

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

Question 27

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 28

Which of the following is NOT an argument for OpenReport?

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

Question 29

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

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

Question 30

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 31

OpenReport is an Access macro ____.

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

Question 32

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

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

Question 33

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

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

Question 34

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 35

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

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

Question 36

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

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

Question 37

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

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

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

Which of the following is NOT a common macro action?

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

Question 40

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 41

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

Question 42

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

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

Question 43

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

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

Question 44

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

Question 45

The _____ button executes the selected Access macro.

Question 46

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

Question 47

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

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

Question 48

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 49

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 50

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

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

Question 51

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 52

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 53

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 54

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 55

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

Question 56

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 57

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

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

Question 58

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 59

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 60

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

Question 61

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 62

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 63

List four of the major benefits of using macros.

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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 71

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

Question 72

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

Question 73

A secure database allows you to run macros and VBA.

Question 74

Conditional expressions result in a numeric value. _____

Question 75

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 76

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

Question 77

Name three ways that you can run a macro.

Question 78

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

Question 79

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

Question 80

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