Exam 12: Creating Macros

Explore all topics

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?

(Short Answer)

4.9/5

(36)

Question 61

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

(True/False)

4.9/5

(27)

Question 62

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

(True/False)

4.8/5

(42)

Question 63

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

(Multiple Choice)

4.8/5

(29)

Question 64

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

(True/False)

4.8/5

(34)

Question 65

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

(Multiple Choice)

5.0/5

(40)

Question 66

A secure database allows you to run macros and VBA.

(True/False)

4.7/5

(32)

Question 67

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

(True/False)

4.8/5

(26)

Question 68

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

(Short Answer)

4.9/5

(38)

Question 69

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

(True/False)

4.9/5

(31)

Question 70

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

(Multiple Choice)

4.8/5

(43)

Question 71

Showing 61 - 71 of 71

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

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

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

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

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

A secure database allows you to run macros and VBA.

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

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

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters