Question 1

Certain ________ are available for certain table events.
A)Before events
B)After events
C)Data actions
D)Data blocks

Accepted Answer

The answer of Certain ________ are available for certain table...

Question 2

Trusted macros have been known to add,edit,or remove data from a database and often spread to other databases or even to the user's computer.

Accepted Answer

The answer of Trusted macros have been known to add,edit,or...

Question 3

The Action Catalog consists of three different groups: Program Flow,Actions,and In this Database.

Accepted Answer

The three groups in the Action Catalog are Program Flow, Actions, and In this Database.

Question 4

Both the number and complexity of macros can grow over time as the business grows and needs change.

Accepted Answer

As a business grows and changes, the number and complexity of macros can increase to meet new needs and demands.

Question 5

Stand-alone macros are typically used to implement business logic into tables and automatically set values in fields.

Accepted Answer

The answer of Stand-alone macros are typically used to implement...

Question 6

If the Single Step feature is on when the macro ends,it automatically turns off.

Accepted Answer

The answer of If the Single Step feature is on...

Question 7

Macro Settings are part of the Trust Center Settings and can be modified based on the needs of the organization.

Accepted Answer

Macro Settings are indeed part of the Trust Center Settings and can be customized according to the organization's requirements.

Question 8

If part of your macro is functioning correctly,then you can begin single stepping at a specific point in the macro by adding the Single Step macro action at the point where you wish to begin single stepping.

Accepted Answer

This statement is true. Adding the Single Step macro action allows you to begin single stepping at a specific point in the macro.

Question 9

Macros can add functionality to reports and forms,as well as the controls that forms and reports contain.

Accepted Answer

Macros can be used to automate tasks and add functionality to forms and reports, including the controls within them.

Question 10

________ contain an area to add one or more data actions,and it executes all the actions contained as part of its operation.
A)Before events
B)After events
C)Data actions
D)Data blocks

Accepted Answer

Data blocks contain an area to add one or more data actions, and they execute all the actions contained as part of their operation.

Question 11

Any file that you put in a trusted location can be opened without being checked by the Trust Center security feature.

Accepted Answer

Any file placed in a trusted location is considered safe and does not need to be checked by the Trust Center security feature.

Question 12

When a macro group is created,only the name appears in the navigation form regardless of how many submacros it contains.

Accepted Answer

The answer of When a macro group is created,only the...

Question 13

Many businesses are cutting waste by exporting reports and having them sent in an e-mail instead of having them printed directly from a database.

Accepted Answer

Exporting reports and having them sent in an e-mail instead of having them printed directly from a database can help businesses cut down on paper waste.

Question 14

Actions can be added to the macro by simply selecting one from the Add New Macro list or by searching the Action Catalog.

Accepted Answer

The answer of Actions can be added to the macro...

Question 15

Macros can be printed by clicking the Design tab on the Ribbon,clicking Database Documenter in the Analyze group,clicking the Macros tab,and then clicking the macro to be printed.

Accepted Answer

Macros are not printed through the Design tab or Database Documenter. Instead, they are typically printed by opening the macro in Design view and using the print options available in the application.

Question 16

Data macros can be executed directly from the Navigation Pane by double-clicking the macro object,clicking Run in Design view,or by attaching the macro to a database object,like a button or text field.

Accepted Answer

Data macros in Access cannot be executed directly from the Navigation Pane; they are triggered by events on tables, unlike regular macros which can be run directly.

Question 17

After each action the Macro Single Step dialog box appears that shows the name of the macro,the value of any conditions,the name of the action about to be executed,and the arguments for the action.

Accepted Answer

This statement accurately describes the behavior of the Single Step feature in Microsoft Access.

Question 18

Embedded macros are displayed in the Navigation Pane.

Accepted Answer

Embedded macros are not displayed in the Navigation Pane; they are part of the objects they are embedded in, such as forms or reports.

Question 19

An AutoExec macro is a macro group that assigns keys on the keyboard to execute each submacro.

Accepted Answer

An AutoExec macro is a type of macro in Microsoft Access that runs automatically when a database is opened, not a macro group for assigning keys.

Question 20

The SetWarnings action is used often to suppress warning messages when performing various tasks like running update queries and delete queries.

Accepted Answer

The SetWarnings action is indeed used to suppress warning messages in various tasks like running update and delete queries.

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

Certain ________ are available for certain table events.