Question 1

When the MessageBox action is executed the macro is paused so the message can be displayed.You need to click ________ in order for the macro to continue.
A)Cancel
B)Continue
C)OK
D)Go

Accepted Answer

Clicking OK will acknowledge the message and allow the macro to continue.

Question 2

In reference to a message box that appears during the execution of a macro,the frequency and duration of the ________ depend on the hardware,which varies between computers.
A)AutoExec
B)MessageBox
C)SelectObject
D)Beep

Accepted Answer

The frequency and duration of the "Beep" depend on the hardware, as different computers may have different sound capabilities.

Question 3

A(n)________ is a macro that is automatically executed when the database is opened.
A)GoToControl
B)OpenForm
C)AutoExec
D)MessageBox

Accepted Answer

An AutoExec macro is automatically executed when the database is opened, making it the best choice for this scenario. GoToControl, OpenForm, and MessageBox are all macros that can be used in various situations, but they do not automatically execute when the database is opened.

Question 4

Each submacro in a macro group must have a(n)________ name.
A)event
B)unique
C)command
D)submacro

Accepted Answer

Each submacro within a macro group must have a unique name to differentiate it from the other submacros in the group.

Question 5

The above table is an example of a(n)________.
A)Group
B)Action Catalog
C)Program Flow
D)Process flow

Accepted Answer

The table appears to show a process flow, with various steps labeled and numbered for a specific process.

Question 6

The ________ action allows the user to bypass all the prompts that accompany various actions in a database,such as running an update query and importing data into a table.
A)SetWarnings
B)AutoExec
C)GoToControl
D)SelectObject

Accepted Answer

The SetWarnings action allows the user to bypass all the prompts in a database, such as running an update query and importing data into a table. This is useful when the user is certain about the action they are taking and do not want to be prompted each time. AutoExec runs the specified macro(s) automatically when the database is opened. GoToControl moves the focus to a specified control on a form or a report. SelectObject selects the specified object in the Navigation Pane.

Question 7

________ macros are triggered by database events.
A)Data
B)AutoExec
C)AutoKey
D)Embedded

Accepted Answer

Embedded macros are triggered by database events as they are associated with specific events in forms, reports, or controls within a database.

Question 8

________ can easily be added to other macros by using the RunMacro or OnError actions,or they can be easily assigned to events.
A)Submacros
B)Actions
C)AutoKeys
D)Groups

Accepted Answer

Submacros can be added to other macros using the RunMacro or OnError actions and can be assigned to events, allowing for modular and reusable macro components.

Question 9

Which of the following is NOT true regarding macro groups?
A)When a macro group is created,only the name appears in the Navigation Pane regardless of how many submacros it contains.
B)It is best practice to create logical groups based on function and purpose when creating them.
C)Access requires the submacros in a macro group to be similar.
D)When a macro group is executed directly from the Navigation Pane or by clicking Run in Design view,only the first submacro is executed.

Accepted Answer

This statement is not true because Access does not require the submacros in a macro group to be similar. The submacros can perform completely different tasks and have different actions.

Question 10

By embedding the macro it becomes ________,and if you export the form into another database,any macros embedded will remain with the object.
A)portable
B)manageable
C)functional
D)efficient

Accepted Answer

By embedding the macro, it becomes portable, which means it can be easily transferred to other databases without losing its functionality. This is because the macro will remain with the object when exported.

Question 11

Because submacros cannot be executed from the ________,you can make the process easier by assigning keys to each submacro so that reports can be printed simply by pressing keys on the keyboard.
A)Macro Tools Design tab
B)navigation form
C)Navigation Pane
D)Action Catalog

Accepted Answer

The Navigation Pane allows you to organize and manage objects in your database. It does not have the ability to execute submacros. Assigning keys to submacros can help simplify the process of printing reports, making it easier for users to access them by simply pressing keys on the keyboard.

Question 12

By default the Action Catalog and Add New Action combo box only show actions that execute in nontrusted databases.To see all actions,click Show All Actions in the ________ on the Design tab.
A)Tools group
B)Show/Hide group
C)Views group
D)Field,Record & Table Events group

Accepted Answer

The "Show All Actions" option is located in the Show/Hide group on the Design tab.

Question 13

A ________ is two or more submacros that are similar in function and are stored under the same macro name.
A)macro group
B)data actions group
C)submacro group
D)data blocks group

Accepted Answer

A macro group is two or more submacros that are similar in function and are stored under the same macro name.

Question 14

________ are useful to alert the user that an action has been completed,but message boxes could also be used for custom error messages.
A)Error messages
B)Modal messages
C)Message boxes
D)Warnings boxes

Accepted Answer

While error messages and warning boxes are intended to notify the user of an issue, message boxes are typically used to communicate that an action has been completed successfully. However, message boxes can also be used for other types of messages, including custom error messages. Modal messages are similar to message boxes, but they require the user to interact with them before they can continue using the program.

Question 15

An ________ can be bypassed by holding down the Shift key when opening the database.
A)AutoKey
B)AutoExec macro
C)Action
D)Action Group

Accepted Answer

An AutoExec macro is automatically executed when a database is opened. It could contain security measures such as a login screen or restrictions on certain actions. However, holding down the Shift key when opening the database disables any AutoExec macros, allowing the user to bypass those security measures.

Question 16

________ that describe the purpose of a macro or complex program flows are considered best practice but are many times neglected by database programmers.
A)Comments
B)Notes
C)Group
D)Data Actions

Accepted Answer

Comments are essential for documenting the purpose and functionality of a macro or complex program flows. They help other programmers understand the code and provide context for future modifications. Neglecting to include comments can make the code difficult to maintain and understand.

Question 17

A ________ occurs when an action is completed on any given object.The action could be,for example,a simple click of the mouse or entering information into a specific field.
A)modal message
B)submacro
C)database event
D)command

Accepted Answer

A database event occurs when an action, such as a mouse click or data entry, is completed on a database object.

Question 18

Macros are composed of actions that often contain ________ to determine when and how to perform the action.
A)subactions
B)messages
C)programming languages
D)logic

Accepted Answer

Macros often contain logic to determine when and how to perform the action.

Question 19

A(n)________ macro is a macro group that assigns keys on the keyboard to execute each submacro.
A)Embedded
B)AutoExec
C)Data
D)AutoKeys

Accepted Answer

The AutoKeys macro allows users to assign specific keys on the keyboard to execute submacros within a larger macro group. This can be useful for automating repetitive tasks and improving overall productivity in Microsoft Office programs such as Excel and Word.

Question 20

Which of the following is NOT a factor to consider when automating processes?
A)Taking the time to create a process flow that describes the actions and reasons for those actions can reduce the chance of errors.
B)Macros can be used to automate complex sets of actions.
C)It is important to carefully think through all the actions that a macro will be executing to complete the tasks before saving the macro.
D)Taking the time to create a process flow that describes the actions and reasons for those actions can save time.

Accepted Answer

The answer of Which of the following is NOT a...

Quiz 12: Workshop 12: Create a Refined User Experience With Macros

When the MessageBox action is executed the macro is paused so the message can be displayed.You need to click ________ in order for the macro to continue.

In reference to a message box that appears during the execution of a macro,the frequency and duration of the ________ depend on the hardware,which varies between computers.

A(n) ________ is a macro that is automatically executed when the database is opened.

Each submacro in a macro group must have a(n) ________ name.

The above table is an example of a(n) ________.

The ________ action allows the user to bypass all the prompts that accompany various actions in a database,such as running an update query and importing data into a table.

________ macros are triggered by database events.

________ can easily be added to other macros by using the RunMacro or OnError actions,or they can be easily assigned to events.

Which of the following is NOT true regarding macro groups?

By embedding the macro it becomes ________,and if you export the form into another database,any macros embedded will remain with the object.

Because submacros cannot be executed from the ________,you can make the process easier by assigning keys to each submacro so that reports can be printed simply by pressing keys on the keyboard.

By default the Action Catalog and Add New Action combo box only show actions that execute in nontrusted databases.To see all actions,click Show All Actions in the ________ on the Design tab.

A ________ is two or more submacros that are similar in function and are stored under the same macro name.

________ are useful to alert the user that an action has been completed,but message boxes could also be used for custom error messages.

An ________ can be bypassed by holding down the Shift key when opening the database.

________ that describe the purpose of a macro or complex program flows are considered best practice but are many times neglected by database programmers.

A ________ occurs when an action is completed on any given object.The action could be,for example,a simple click of the mouse or entering information into a specific field.

Macros are composed of actions that often contain ________ to determine when and how to perform the action.

A(n) ________ macro is a macro group that assigns keys on the keyboard to execute each submacro.

Which of the following is NOT a factor to consider when automating processes?