Question 1

Match between columns
                        Premises: A state, condition, or occurrence detectable by Access.

Accepted Answer

The Answer of SelectObject and RunMenuCommand and SQL and OpenForm is...

Question 2

Macros may be selected and run from the Macros group in the Navigation Pane or the ____.

Accepted Answer

A)  Query Wizard 
B)  Form Wizard 
C)  Report Design View 
D)  Run Macro dialog box 
A)  Query Wizard 
B)  Form Wizard 
C)  Report Design View 
D)  Run Macro dialog box

Question 3

In the accompanying figure, which numbered arrow indicates that a comment has ended?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 4

A system table that keeps track of the names, types, and other characteristics of every object in an Access database is the ____________________ table.

Accepted Answer

The answer of A system table that keeps track of...

Question 5

Which of the following is an example of a submacro within a macro?

Accepted Answer

A)  OnClick.OpenCustomerTable 
B)  frmInvoice.OnClose 
C)  tblBilling.ListCustomer 
D)  mcrLatePayment.OpenBillingTable 
A)  OnClick.OpenCustomerTable 
B)  frmInvoice.OnClose 
C)  tblBilling.ListCustomer 
D)  mcrLatePayment.OpenBillingTable

Question 6

In the accompanying figure, which numbered arrow indicates the Build button?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 7

Which of the following is an example of an event property?

Accepted Answer

A)  OnClose 
B)  Input Mask 
C)  Validation Rule 
D)  Border Style 
A)  OnClose 
B)  Input Mask 
C)  Validation Rule 
D)  Border Style

Question 8

In the accompanying figure, the action name for which arguments are shown is the ____ action.

Accepted Answer

A)  OpenQuery 
B)  Data Entry Operations 
C)  Program Flow 
D)  OnClick 
A)  OpenQuery 
B)  Data Entry Operations 
C)  Program Flow 
D)  OnClick

Question 9

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.
A message box has been included in a macro that runs in the client billing form.  Elaina wants the message box to display this icon
  in the message box to get the user's attention.  What does this icon represent?

Accepted Answer

A)  Warning? 
B)  Warning! 
C)  Critical 
D)  Information 
A)  Warning? 
B)  Warning! 
C)  Critical 
D)  Information

Question 10

Match between columns
                        Premises: The action that selects and runs a command on the ribbon.

Accepted Answer

The Answer of SelectObject and View Argument and GoToControl and is...

Question 11

The development environment in Access that is used to create, view, and modify macros is the ____.

Accepted Answer

A)  SQL server 
B)  Visual Basic 
C)  Macro Designer 
D)  ODBC database 
A)  SQL server 
B)  Visual Basic 
C)  Macro Designer 
D)  ODBC database

Question 12

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

Accepted Answer

The Answer of View Argument and OpenForm and GoToControl and is...

Question 13

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 14

Match between columns
                        Premises: A standard language used in querying, updating, and managing relational databases.

Accepted Answer

The Answer of OpenForm and View Argument and RunMenuCommand and is...

Question 15

A ____ is a recorded action, or set of actions that automates repetitive tasks.

Accepted Answer

A)  command 
B)  macro 
C)  filter 
D)  code 
A)  command 
B)  macro 
C)  filter 
D)  code

Question 16

Two methods are available to turn off single step mode, one method is to use the Single Step command on the DESIGN tab, the other method is to click the ____________________ button in the Macro Single Step window.

Accepted Answer

The answer of Two methods are available to turn off...

Question 17

A state, condition, or occurrence detectable by Access is a(n) __________________.

Accepted Answer

The answer of A state, condition, or occurrence detectable by...

Question 18

The ____________________ action finds the first record that meets the criteria specified in the action's argument(s) or the next record if the action is used again.

Accepted Answer

The answer of The ____________________ action finds the first record...

Question 19

A macro attached to the OnOpen property in a form will execute its actions each time the form is opened.

Accepted Answer

A) True 
 B)False

Question 20

It is not possible to create a form without using a table or query object as the source for the form.

Accepted Answer

A) True 
 B)False

Macros may be selected and run from the Macros group in the Navigation Pane or the ____.

In the accompanying figure, which numbered arrow indicates that a comment has ended?

A system table that keeps track of the names, types, and other characteristics of every object in an Access database is the ____________________ table.

Which of the following is an example of a submacro within a macro?

In the accompanying figure, which numbered arrow indicates the Build button?

Which of the following is an example of an event property?

In the accompanying figure, the action name for which arguments are shown is the ____ action.

The development environment in Access that is used to create, view, and modify macros is the ____.

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

A ____ is a recorded action, or set of actions that automates repetitive tasks.

Two methods are available to turn off single step mode, one method is to use the Single Step command on the DESIGN tab, the other method is to click the ____________________ button in the Macro Single Step window.

A state, condition, or occurrence detectable by Access is a(n) __________________.

The ____________________ action finds the first record that meets the criteria specified in the action's argument(s) or the next record if the action is used again.

A macro attached to the OnOpen property in a form will execute its actions each time the form is opened.

It is not possible to create a form without using a table or query object as the source for the form.

Managing Your Files

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 Sharing a Database

Filters

Exam 11: Automating Tasks With Macros

Macros may be selected and run from the Macros group in the Navigation Pane or the ____.

In the accompanying figure, which numbered arrow indicates that a comment has ended?

A system table that keeps track of the names, types, and other characteristics of every object in an Access database is the ____________________ table.

Which of the following is an example of a submacro within a macro?

In the accompanying figure, which numbered arrow indicates the Build button?

Which of the following is an example of an event property?

In the accompanying figure, the action name for which arguments are shown is the ____ action.

The development environment in Access that is used to create, view, and modify macros is the ____.

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

A ____ is a recorded action, or set of actions that automates repetitive tasks.

Two methods are available to turn off single step mode, one method is to use the Single Step command on the DESIGN tab, the other method is to click the ____________________ button in the Macro Single Step window.

A state, condition, or occurrence detectable by Access is a(n) __________________.

The ____________________ action finds the first record that meets the criteria specified in the action's argument(s) or the next record if the action is used again.

A macro attached to the OnOpen property in a form will execute its actions each time the form is opened.

It is not possible to create a form without using a table or query object as the source for the form.

Managing Your Files

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 Sharing a Database

Filters