Question 1

A SQL keyword after which selection criteria is listed in a SQL SELECT statement.

Accepted Answer

A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument 
A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument

Question 2

Misaki is a new Reservation Specialist for an event rental company.She has asked the database administrator,Kirk,to develop an interface for her to access the database objects she needs because she is not familiar with Access.
-Kirk has determined he needs a list box of all of the queries in the database to include in the interface he is developing.Access maintains special tables that store information about the structure of the objects in the database.The ____ system table,stores information about the names,types,and other characteristics of every object in a database.Kirk will write an SQL statement that includes information from this table.

Accepted Answer

A) USysRibbon 
B) MSysObjects 
C) MSysQueries 
D) MSysSelect 
A) USysRibbon 
B) MSysObjects 
C) MSysQueries 
D) MSysSelect

Question 3

A standard language used in querying,updating,and managing relational databases.

Accepted Answer

A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument 
A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument

Question 4

It is not possible to drag an action from the Action Catalog to a specific location in the Macro Designer.

Accepted Answer

A) True 
 B)False

Question 5

A database developer may use either a macro or VBA code to display a user interface for the database.

Accepted Answer

A) True 
 B)False

Question 6

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 7

​A piece of data that is required by an action

Accepted Answer

A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument 
A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

What are some advantages of including submacros in a single macro instead of creating them all as separate macros?

Accepted Answer

Student answers may vary.
Creating subma

Question 10

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 11

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.
-In a different macro,Elaina would like to locate the first or next record that meets a specific set of criteria.Which Access action can be added to the macro that will meet her demand?

Accepted Answer

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

Question 12

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 13

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 14

In a SQL SELECT statement a field name enclosed in square brackets like this [Last Name] most likely refers to which of the following field names from the selected table?

Accepted Answer

A) lName 
B) Lname 
C) LastName 
D) Last Name 
A) lName 
B) Lname 
C) LastName 
D) Last Name

Question 15

In an SQL SELECT statement,fields to be displayed are listed after the keyword ____.

Accepted Answer

A) WHERE 
B) FIELDS 
C) SELECT 
D) SORT 
A) WHERE 
B) FIELDS 
C) SELECT 
D) SORT

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The action that displays a message box containing a warning or informational message.

Accepted Answer

A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument 
A) OpenForm 
B) RunMenuCommand 
C) message box 
D) SelectObject 
E) event
F)View Argument
G)WHERE
H)GoToControl
I)FROM
J)SQL
K)Single step
L)Action Catalog button
M)Macro
N)Action
O)OpenForm Action
P)Navigation form
Q)List box control
R)Comment
S)Search box
T)Argument

Question 18

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 19

Misaki is a new Reservation Specialist for an event rental company.She has asked the database administrator,Kirk,to develop an interface for her to access the database objects she needs because she is not familiar with Access.
-Kirk will use one of the predefined navigation forms available from the ____ in the Forms group on the Create tab to create the navigation form for the interface.

Accepted Answer

A) Form Wizard 
B) Form Design button 
C) Navigation Gallery 
D) Macro button 
A) Form Wizard 
B) Form Design button 
C) Navigation Gallery 
D) Macro button

Question 20

The only arguments available for the Beep argument are Yes or No.

Accepted Answer

A) True 
 B)False

A SQL keyword after which selection criteria is listed in a SQL SELECT statement.

A standard language used in querying,updating,and managing relational databases.

It is not possible to drag an action from the Action Catalog to a specific location in the Macro Designer.

A database developer may use either a macro or VBA code to display a user interface for the database.

A piece of data that is required by an action

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

What are some advantages of including submacros in a single macro instead of creating them all as separate macros?

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

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

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

In a SQL SELECT statement a field name enclosed in square brackets like this [Last Name] most likely refers to which of the following field names from the selected table?

In an SQL SELECT statement,fields to be displayed are listed after the keyword ____.

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

The action that displays a message box containing a warning or informational message.

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

The only arguments available for the Beep argument are Yes or No.

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 Formsmodule

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

A SQL keyword after which selection criteria is listed in a SQL SELECT statement.

A standard language used in querying,updating,and managing relational databases.

It is not possible to drag an action from the Action Catalog to a specific location in the Macro Designer.

A database developer may use either a macro or VBA code to display a user interface for the database.

​A piece of data that is required by an action

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

What are some advantages of including submacros in a single macro instead of creating them all as separate macros?

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

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

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

In a SQL SELECT statement a field name enclosed in square brackets like this [Last Name] most likely refers to which of the following field names from the selected table?

In an SQL SELECT statement,fields to be displayed are listed after the keyword ____.

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

The action that displays a message box containing a warning or informational message.

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

The only arguments available for the Beep argument are Yes or No.

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 Formsmodule

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

A piece of data that is required by an action