Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The answer of To permanently trust a database, store the...

Question 3

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

Accepted Answer

A) True 
 B)False

Question 4

-As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Accepted Answer

A) True 
 B)False

Question 5

Which of the following would not constitute an event?

Accepted Answer

A)  Adding an action to a macro 
B)  Clicking a command button 
C)  Opening a form 
D)  Closing a form 
A)  Adding an action to a macro 
B)  Clicking a command button 
C)  Opening a form 
D)  Closing a form

Question 6

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?

Accepted Answer

The answer of You are a busy information technology (IT)...

Question 7

All Access events are triggered by the user.

Accepted Answer

A) True 
 B)False

Question 8

The click of a command button or making an entry in a field would be considered a(n) ____.

Accepted Answer

A)  Macro 
B)  Action 
C)  Condition 
D)  Event 
A)  Macro 
B)  Action 
C)  Condition 
D)  Event

Question 9

Match the Macro Design View component with its description.
-Contains conditional expressions that are evaluated either true or false

Accepted Answer

A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button 
A) Action Catalog 
B) If statement 
C) Arguments 
D) Comment 
E) Run button

Question 10

Which of the following is NOT an argument for OpenReport?

Accepted Answer

A)  Report Name 
B)  Default Ribbon 
C)  View 
D)  Window Mode 
A)  Report Name 
B)  Default Ribbon 
C)  View 
D)  Window Mode

Question 11

A table macro allows you to embed macro capabilities directly in a table.

Accepted Answer

A) True 
 B)False

Question 12

-In the figure above, what is the name of the first action?

Accepted Answer

A)  OpenReport 
B)  Macro1 
C)  Window Mode 
D)  MessageBox 
A)  OpenReport 
B)  Macro1 
C)  Window Mode 
D)  MessageBox

Question 13

-You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro as shown in the figure helps you solve the problem.

Accepted Answer

Single stepping a macro breaks

Question 14

The _____ button executes the selected Access macro.

Accepted Answer

The answer of The _____ button executes the selected Access...

Question 15

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

Accepted Answer

A)  exclamation 
B)  conditional 
C)  macro 
D)  bang 
A)  exclamation 
B)  conditional 
C)  macro 
D)  bang

Question 16

The best way to make a macro obviously available for many different forms would be to ____.

Accepted Answer

A)  Click the Run button from the DATABASE TOOLS tab 
B)  Run the macro from Macro Design View 
C)  Assign the macro to a command button on the first form the user opens 
D)  Assign the macro to the Ribbon 
A)  Click the Run button from the DATABASE TOOLS tab 
B)  Run the macro from Macro Design View 
C)  Assign the macro to a command button on the first form the user opens 
D)  Assign the macro to the Ribbon

Question 17

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

Accepted Answer

The answer of A(n) _____ is a specific activity that...

Question 18

-As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

Accepted Answer

The answer of  
-As shown in the figure, _____...

Question 19

A macro may contain one or more _____, the tasks that you want Access to perform.

Accepted Answer

The answer of A macro may contain one or more...

Question 20

-As shown in the figure, a(n) _____ expression results in either a true or false answer.

Accepted Answer

The answer of  
-As shown in the figure, a(n)...

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

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

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

-As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Which of the following would not constitute an event?

All Access events are triggered by the user.

The click of a command button or making an entry in a field would be considered a(n) ____.

Match the Macro Design View component with its description. -Contains conditional expressions that are evaluated either true or false

Which of the following is NOT an argument for OpenReport?

A table macro allows you to embed macro capabilities directly in a table.

-In the figure above, what is the name of the first action?

-You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro as shown in the figure helps you solve the problem.

The _____ button executes the selected Access macro.

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

The best way to make a macro obviously available for many different forms would be to ____.

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

-As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

A macro may contain one or more _____, the tasks that you want Access to perform.

-As shown in the figure, a(n) _____ expression results in either a true or false answer.

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

Exam 14: Creating Macros

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

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

When creating a command button, make sure the Control Wizards button is selected in order to invoke the Command Button Wizard.

-As shown in the figure, you create a macro in Access by using the Macro Recorder View. _____

Which of the following would not constitute an event?

All Access events are triggered by the user.

The click of a command button or making an entry in a field would be considered a(n) ____.

Match the Macro Design View component with its description. -Contains conditional expressions that are evaluated either true or false

Which of the following is NOT an argument for OpenReport?

A table macro allows you to embed macro capabilities directly in a table.

-In the figure above, what is the name of the first action?

-You have been asked to troubleshoot a macro that doesn't work. Explain why single stepping a macro as shown in the figure helps you solve the problem.

The _____ button executes the selected Access macro.

[Forms]![CustomerEntry]![CustPhone] is an example of _____ notation.

The best way to make a macro obviously available for many different forms would be to ____.

A(n) _____ is a specific activity that occurs within the database, such as clicking a command button, moving from record to record, editing data, or opening and closing a form.

-As shown in the figure, _____ is a useful Access macro action because it displays an informational message to the user.

A macro may contain one or more _____, the tasks that you want Access to perform.

-As shown in the figure, a(n) _____ expression results in either a true or false answer.

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