Question 1

​A form with tabs that allows you to display database objects in an organized way to users

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

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

Accepted Answer

A) True 
 B)False

Question 3

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.
-In the SQL SELECT statement,Kirk must identify the object type for queries using code that SQL can interpret.In the Access system table,the field value for the query object type is ____ and will follow [Type]= in the statement.

Accepted Answer

A) 1 
B) 3 
C) 5 
D) 7 
A) 1 
B) 3 
C) 5 
D) 7

Question 4

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 5

A(n)____ is a piece of data required by an action in a macro.

Accepted Answer

A) code 
B) argument 
C) message 
D) pointer 
A) code 
B) argument 
C) message 
D) pointer

Question 6

A SQL keyword after which the tables used in a query are 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 7

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 8

In single step mode,the macro may be stopped at any time by clicking the ___ button.

Accepted Answer

A) Step 
B) Single Step 
C) Stop All Macros 
D) Continue 
A) Step 
B) Single Step 
C) Stop All Macros 
D) Continue

Question 9

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 10

An Access action that finds the first record (or the next record,if the action is used again)that meets specified criteria.

Accepted Answer

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

Question 11

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

Accepted Answer

A) True 
 B)False

Question 12

Every system query name begins with the ˜ (tilde)character.____________________

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 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

A form with tabs that allows you to display database objects in an organized way to users

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

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

A(n)____ is a piece of data required by an action in a macro.

A SQL keyword after which the tables used in a query are listed in a SQL SELECT statement.

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

In single step mode,the macro may be stopped at any time by clicking the ___ button.

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

An Access action that finds the first record (or the next record,if the action is used again)that meets specified criteria.

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

Every system query name begins with the ˜ (tilde)character.____________________

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

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

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

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 form with tabs that allows you to display database objects in an organized way to users

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

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

A(n)____ is a piece of data required by an action in a macro.

A SQL keyword after which the tables used in a query are listed in a SQL SELECT statement.

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

In single step mode,the macro may be stopped at any time by clicking the ___ button.

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

An Access action that finds the first record (or the next record,if the action is used again)that meets specified criteria.

Edit is the default setting for the Data Mode argument of the OpenTable action.____________________

Every system query name begins with the ˜ (tilde)character.____________________

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

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

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

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 form with tabs that allows you to display database objects in an organized way to users

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