Deck 12: Creating Macros

Question 1

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

Answer 1

A

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

By default, an Access database is trusted.

Question 5

Some arguments, such as the Title argument can be left empty.

Question 6

You can assign a macro to a Ribbon or shortcut menu.

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

Arguments change depending upon the action chosen.

Question 9

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

Question 10

If statements  may contain Else If and Else clauses.

Question 11

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

Question 12

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

Question 13

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 14

____ is a major benefit of using macros.

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

Question 15

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

Question 16

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

Question 17

All Access events are triggered by the user.

Question 18

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 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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 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

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 27

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

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

Question 28

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 29

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

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

Question 30

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 31

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 32

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

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

Question 33

Which of the following is NOT a common macro action?

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

Question 34

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 35

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

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

Question 36

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

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

Question 37

OpenReport is an Access macro ____.

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

Question 38

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 39

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

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

Question 40

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 41

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

Question 42

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

Question 43

The _____ button executes the selected Access macro.

Question 44

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

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

Name three ways that you can run a macro.

Question 50

Conditional expressions result in a numeric value. _____

Question 51

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 52

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

Question 53

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 54

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

Question 55

List four of the major benefits of using macros.

Question 56

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

Question 57

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

Question 58

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 59

A secure database allows you to run macros and VBA.

Question 60

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

Question 61

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

Question 62

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

Question 64

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 65

You have inherited a database with several macros.  Explain why attaching macros to command buttons is a superior way to run a macro as compared to running it from the Database Tools tab on the Ribbon.

Question 66

You are a busy information technology (IT) specialist at a well-known accounting firm. You work with departments throughout the company to help them solve problems and simplify computer tasks.
One of your coworkers asks you to explain the difference between Excel and Access with regard to creating macros and VBA.  What do you tell him?

Question 67

A conditional expression is an expression that results in a true or false value.

Question 68

You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro helps you solve the problem.

Question 69

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

Question 70

You are a busy information technology (IT) specialist at a well-known accounting firm. You work with departments throughout the company to help them solve problems and simplify computer tasks.
The Payroll department needs you to improve its database's ease of use by adding some kind of audible warning sound and an automatic message to tell the user when a data entry mistake has been made.  What are the names of the two macro actions you would use in a macro to achieve this?

Question 71

You are a busy information technology (IT) specialist at a well-known accounting firm. You work with departments throughout the company to help them solve problems and simplify computer tasks.
You are asked to automate some routine tasks for the Accounts Payable department.  These are:
a. Finding the first record that meets certain criteria
b. Maximizing an active window to fill the Access window
c. Closing a window
What are the names of the 3 macro actions you would use in a macro to complete these tasks?