Deck 11: Creating and Running Macros

Question 1

The Before Update form event is triggered when the user begins to delete a record, but before the record is deleted.

Answer 1

False

Question 2

A comment can affect the way the macro is executed.

Answer 2

False

Question 3

When you record a macro, you can include multiple actions in it.

Answer 3

True

Question 4

You can create a macro in the Macro window and then attach it to the object.

Question 5

Embedded macros have queries that run the macro, such as On Click.

Question 6

As you create a command button in an existing form with form operations, Access will add an event that is applicable to the object.

Question 7

Macro settings can be viewed by clicking the View tab on the Ribbon, and then clicking the Macro Security button in the Code group.

Question 8

A(n) embedded query can be part of another object, such as a command button.

Question 9

A macro automates common, repetitive tasks you perform in Access, thereby saving disk space.

Question 10

To run an embedded macro, you simply click on the Run button.

Question 11

When a macro is being ____, all of the selections you make are translated into code.

A) created
B) recorded
C) compiled
D) run

Question 12

You can create an object and have a macro embedded as you work through a wizard.

Question 13

As a best practice, you should set the security level in Access to Disable all macros with notification or Disable all macros except digitally signed macros.

Question 14

If a virus attaches itself to a macro, it can cause damage when you ____ the macro.

A) create
B) compile
C) run
D) record

Question 15

When you run a macro, Access performs the actions listed in the Macro window in alphabetical order.

Question 16

____ is the program used to create macros.

A) Visual Basic for Applications (or VBA)
B) Linux
C) C++
D) BASIC

Question 17

To run a macro means to have it perform a(n) ____, automated task.

A) simultaneous
B) adhoc
C) programmed
D) quick

Question 18

The Disable all macros with notification option is the default setting unless you choose another one.

Question 19

To edit a macro, you work in the Macro window.

Question 20

By running a macro, you can ensure ____.

A) complexity
B) autonomy
C) security
D) accuracy

Question 21

A(n) ____________________ is a series of actions that you want Access to perform.

Question 22

____ macros have events that run the macro.

A) Event
B) Embedded
C) Critical
D) Advanced

Question 23

FIGURE AC 11-1 In the accompanying figure, the area where you type the name of an action to search for is referenced by ____.

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

Question 24

Case AC 11-2 Craig has responsibility for updating the frozen food inventory for the Frosty Freeze Snack Shop each night. On Sunday evenings, Craig wants to print five forms displaying weekly summary inventory results that he provides to his five different suppliers and his manager the next morning. He does not want the form to remain open after it is printed. As Shelly is a part-time employee working at the Frosty Freeze Snack Shop to help pay her way through college, Craig asks Shelly if she can write the macro to open and print the report. Unfortunately, when the inventory form ran using the new macro, all of the forms did not close after the macro ran. This most likely occurred because ____.

A) Shelly did not run and test the macro after she created it
B) the user entered the wrong field value
C) the computer did not have enough processing power to run the macro correctly
D) the macro was programmed using C++

Question 25

You choose macro security level settings in the ____ section of the Access Options dialog box.

A) Trust Center
B) Trust Options
C) Macro
D) Macro Options

Question 26

To run a macro in the Navigation pane, right-click the macro name, and then click ____ on the shortcut menu.

A) Execute
B) Query
C) OK
D) Run

Question 27

After you select an action, Access displays the argument(s) ____ the action.

A) on top of
B) below
C) to the left of
D) to the right of

Question 28

Within the Run Macro dialog box, click the ____ appearing next to the Macro Name text box to provide a list of all the macros in the database.

A) arrow
B) open button
C) list box
D) control field

Question 29

You would use the ____ form event to run an embedded macro when a form is closed.

A) On Close
B) Close
C) On Unload
D) Unload

Question 30

Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. The account manager insists that no changes should be made to the report query form when it is opened. You assure her that this can be accomplished by ____.

A) enabling passive mode
B) enabling an embedded macro
C) disabling viruses
D) creating the form with a Read Only mode

Question 31

Case AC 11-2 Craig has responsibility for updating the frozen food inventory for the Frosty Freeze Snack Shop each night. On Sunday evenings, Craig wants to print five forms displaying weekly summary inventory results that he provides to his five different suppliers and his manager the next morning. He does not want the form to remain open after it is printed. As Shelly is a part-time employee working at the Frosty Freeze Snack Shop to help pay her way through college, Craig asks Shelly if she can write the macro to open and print the report. As Shelly starts writing the macro she decides to include multiple actions starting with the print action. Craig expresses some concern as he recalls from his Advanced Access 2010 class that ____.

A) if he does not have a printer connected to his computer, the macro will not run
B) when recording a macro, Access can only support single actions
C) if you want to print a report, you will probably want to select an action that first opens the report and then select the action to print the report
D) Shelly should first be making the report open in a Read Only mode

Question 32

When you create a command button with an embedded macro, you can view the event and the embedded macro using the ____ Sheet.

A) Command
B) Macro Embed
C) Property
D) Event

Question 33

FIGURE AC 11-1 In the accompanying figure, ____ points to the area where you click to display a list of actions.

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

Question 34

Comments appear in ____ in the macro window, making them easy to identify.

A) red
B) blue
C) turquoise
D) green

Question 35

Because macros often need to be changed, it is a good idea to include a comment for each ____.

A) macro action
B) macro field
C) macro filter
D) query

Question 36

To run a macro using the Database Tools tab, click the Run Macro button in the Macro group, select the macro in the Run Macro dialog box, and then click the ____ button.

A) Execute
B) Query
C) OK
D) Run

Question 37

Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. You explain that you will create a macro as part of the solution because ____.

A) viruses cannot infect macros
B) macros cannot be disabled
C) macros automate repetitive tasks, such as running queries
D) links to the database records make the macro query run faster

Question 38

To help protect your data from the corruption caused by a virus hidden in a macro, you can set one of ____ macro security levels in Access.

A) one
B) two
C) three
D) four

Question 39

The filter in a macro is typically based on a ____ in the database.

A) record
B) filter
C) query
D) field

Question 40

To run a macro using the Macro Tools Design tab, click the ____ button in the Tools group.

A) Execute
B) Query
C) OK
D) Run

Question 42

A(n) ____________________ macro is a macro that performs an action within an object.

Question 43

To create a macro, you open the ____________________ window by clicking the Create tab and then clicking the Macro button in the Macros & Code group.

Question 44

A(n) ____________________ is a computer program that is designed to reproduce itself by attaching to other programs in a computer.

Question 45

After you create and save a macro, you need to ____________________ the macro in order to have it perform the recorded steps.

Question 46

Explain how Access helps to protect data from corruption caused by a virus hidden in a macro. Be sure to explain possible options.