Question 1

The Access action that selects a specified object so that an action can be run that applies to the object.

Accepted Answer

A) SelectObject 
B) Apply Filter 
C) OpenForm 
D) RunMacro 
A) SelectObject 
B) Apply Filter 
C) OpenForm 
D) RunMacro

Question 2

Unsafe actions available in the Action Catalog when Show All Actions is enabled while creating or modifying a macro are identified by ____.

Accepted Answer

A) a red exclamation mark 
B) the name of the action in red letters 
C) an "Unsafe Action" ScreenTip 
D) "Trusted" ScreenTip 
A) a red exclamation mark 
B) the name of the action in red letters 
C) an "Unsafe Action" ScreenTip 
D) "Trusted" ScreenTip

Question 3

Briefly explain how to embed submacros, subforms, subqueries, and subreports in macro, form, query, and report Access objects.

Accepted Answer

Student answers will vary but should inc

Question 4

To define the data that is retrieved from a database and how the data is presented, SQL uses the SELECT statement.____________________

Accepted Answer

A) True 
 B)False

Question 5

Case-Based Critical Thinking Questions
Case 10-1
Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions.
-As Elaina continues to automate the database, she discovers that several of her macros are related.  To make maintenance of the database more manageable, she decides to create ____ within a macro to consolidate the related macros.

Accepted Answer

A) actions 
B) event properties 
C) submacros 
D) event procedures 
A) actions 
B) event properties 
C) submacros 
D) event procedures

Question 6

Which of the following describe the five SQL statement types?

Accepted Answer

A) modify, update, delete, insert, create 
B) select, modify, remove, insert, create 
C) select, update, delete, insert, create 
D) remove, update, delete, add, rename 
A) modify, update, delete, insert, create 
B) select, modify, remove, insert, create 
C) select, update, delete, insert, create 
D) remove, update, delete, add, rename

Question 7

In a macro, a phrase is a text description that has no effect on the macro.____________________

Accepted Answer

A) True 
 B)False

Question 8

An object in Access responds to an event, such as clicking on a command button, based on specified event properties.

Accepted Answer

A) True 
 B)False

Question 9

A semi-colon separates multiple arguments for an action in a macro.____________________

Accepted Answer

A) True 
 B)False

Question 10

Case-Based Critical Thinking Questions
Case 10-1
Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions.
-Elaina needs to move the focus to a particular field in the Client form.  Which Access action should she add to the macro?

Accepted Answer

A) GoToControl 
B) OpenForm 
C) FindRecord 
D) SelectObject 
A) GoToControl 
B) OpenForm 
C) FindRecord 
D) SelectObject

Question 11

The SendKeys action available in the Action Catalog when creating a macro is considered to be a trusted action.____________________

Accepted Answer

A) True 
 B)False

Question 12

Most database developers prefer to prevent inexperienced database users from using which type of query?

Accepted Answer

A) action 
B) cross-tab 
C) select 
D) parameter 
A) action 
B) cross-tab 
C) select 
D) parameter

Question 13

Case-Based Critical Thinking Questions
Case 10-1
Elaina is the database administrator for a women's fitness franchise. She has been asked to automate several of the database functions to make it easier for the front desk employees to provide information to clients.  Elaina will create macros to automate the functions.
-Elaina has created a button on the Schedule form that references a macro (mcrOpenScheduleTable)which opens the Schedule table when the button is clicked.  Which event property associated with the button will be assigned the macro name?

Accepted Answer

A) OnClick 
B) OnDblClick 
C) OnEnter 
D) OnMouseMove 
A) OnClick 
B) OnDblClick 
C) OnEnter 
D) OnMouseMove

Question 14

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

Accepted Answer

A) True 
 B)False

Question 15

In a navigation form, the  lower-level tabs are  displayed with the same  background color as the  active top-level tab. ​

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: The action that displays a message box containing a warning or informational message.

Accepted Answer

The Answer of WHERE and  Action Catalog button and is...

Question 17

Which type of form allows the display of database objects using tabs in an organized way to assist users with accessing the different objects.

Accepted Answer

A) bound form 
B) data entry form 
C) reports form 
D) navigation form 
A) bound form 
B) data entry form 
C) reports form 
D) navigation form

Question 18

To hide all arguments for an action, click the Expand Action button in the Collapse/Expand group on the Design tab.____________________

Accepted Answer

A) True 
 B)False

Question 19

Which of these Access objects will work as a subform in a navigation form?

Accepted Answer

A) crosstab queries 
B) macros 
C) table datasheet 
D) select queries 
A) crosstab queries 
B) macros 
C) table datasheet 
D) select queries

Question 20

Match between columns
                        Premises: The action that opens a specified form in a specified view.

Accepted Answer

The Answer of  Comment and event and OpenForm and is...

The Access action that selects a specified object so that an action can be run that applies to the object.

Unsafe actions available in the Action Catalog when Show All Actions is enabled while creating or modifying a macro are identified by ____.

Briefly explain how to embed submacros, subforms, subqueries, and subreports in macro, form, query, and report Access objects.

To define the data that is retrieved from a database and how the data is presented, SQL uses the SELECT statement.____________________

Which of the following describe the five SQL statement types?

In a macro, a phrase is a text description that has no effect on the macro.____________________

An object in Access responds to an event, such as clicking on a command button, based on specified event properties.

A semi-colon separates multiple arguments for an action in a macro.____________________

The SendKeys action available in the Action Catalog when creating a macro is considered to be a trusted action.____________________

Most database developers prefer to prevent inexperienced database users from using which type of query?

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

In a navigation form, the lower-level tabs are displayed with the same background color as the active top-level tab.

Which type of form allows the display of database objects using tabs in an organized way to assist users with accessing the different objects.

To hide all arguments for an action, click the Expand Action button in the Collapse/Expand group on the Design tab.____________________

Which of these Access objects will work as a subform in a navigation form?

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 10: Automating Tasks With Macros

The Access action that selects a specified object so that an action can be run that applies to the object.

Unsafe actions available in the Action Catalog when Show All Actions is enabled while creating or modifying a macro are identified by ____.

Briefly explain how to embed submacros, subforms, subqueries, and subreports in macro, form, query, and report Access objects.

To define the data that is retrieved from a database and how the data is presented, SQL uses the SELECT statement.____________________

Which of the following describe the five SQL statement types?

In a macro, a phrase is a text description that has no effect on the macro.____________________

An object in Access responds to an event, such as clicking on a command button, based on specified event properties.

A semi-colon separates multiple arguments for an action in a macro.____________________

The SendKeys action available in the Action Catalog when creating a macro is considered to be a trusted action.____________________

Most database developers prefer to prevent inexperienced database users from using which type of query?

In a macro containing submacros, the macro name is separated from the submacro name by a period .____________________

In a navigation form, the lower-level tabs are displayed with the same background color as the active top-level tab. ​

Which type of form allows the display of database objects using tabs in an organized way to assist users with accessing the different objects.

To hide all arguments for an action, click the Expand Action button in the Collapse/Expand group on the Design tab.____________________

Which of these Access objects will work as a subform in a navigation form?

Access-Module 1: Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

In a navigation form, the lower-level tabs are displayed with the same background color as the active top-level tab.