Exam 14: Creating Macros

Explore all topics

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

(Essay)

4.8/5

(40)

Question 81

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

(True/False)

4.9/5

(38)

Question 82

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.

(Multiple Choice)

4.9/5

(38)

Question 83

Which of the following is NOT a common macro action?

(Multiple Choice)

4.8/5

(32)

Question 84

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

(Multiple Choice)

4.7/5

(34)

Question 85

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

(Multiple Choice)

4.7/5

(33)

Question 86

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

(Short Answer)

4.8/5

(28)

Question 87

Arguments provide ____.

(Multiple Choice)

4.8/5

(33)

Question 88

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

(True/False)

4.8/5

(26)

Question 89

List four of the major benefits of using macros.

(Essay)

4.8/5

(36)

Question 90

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

(Multiple Choice)

4.9/5

(27)

Question 91

Match the Macro Design View component with its description. -Executes the selected macro

(Multiple Choice)

4.9/5

(35)

Question 92

Showing 81 - 92 of 92

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

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

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.

Which of the following is NOT a common macro action?

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

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

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

Arguments provide ____.

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

List four of the major benefits of using macros.

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

Match the Macro Design View component with its description. -Executes the selected macro

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters