Question 1

When Access opens a form or report,the ____ event occurs.

Accepted Answer

A) Open 
B) Load 
C) View 
D) Link 
A) Open 
B) Load 
C) View 
D) Link B

Question 2

Single step mode remains on for all macros once it is turned on until it is manually turned off.

Accepted Answer

A) True 
 B)False  True

Question 3

Using VBA code,a group of statements may be created that set the event property value to the name of that group of statements;Access will then execute an event ____ when the event occurs.

Accepted Answer

A) procedure 
B) method 
C) property 
D) action 
A) procedure 
B) method 
C) property 
D) action A

Question 4

​Opens a specied form in a specied view

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 5

To create a navigation form using the Navigation gallery,click on the ____ button on the Create tab.

Accepted Answer

A) Navigation 
B) Form Wizard 
C) Form Design 
D) Form 
A) Navigation 
B) Form Wizard 
C) Form Design 
D) Form

Question 6

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)"˜ ORDER BY[NAME];what does [TYPE]=5 indicate?

Accepted Answer

A) the statement is selecting query objects in an Access system table 
B) the statement would like to display only 5 names 
C) the statement is selecting table objects in an Access system table 
D) the statement will select records in groups of 5 
A) the statement is selecting query objects in an Access system table 
B) the statement would like to display only 5 names 
C) the statement is selecting table objects in an Access system table 
D) the statement will select records in groups of 5

Question 7

The default orientation for printing a report many be changed using the ____ feature of Access.

Accepted Answer

A) Form Layout 
B) Report Wizard 
C) Pagination 
D) Print Preview 
A) Form Layout 
B) Report Wizard 
C) Pagination 
D) Print Preview

Question 8

​What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Accepted Answer

It's important to ensure that data is as

Question 9

​Executes one macro action at a time,pausing between actions

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 10

The action that selects a specified object and runs an action that applies to the object.

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 11

Access 2016 provides ____ predefined layouts for navigation forms with different layouts for the placement of tabs and subtabs.

Accepted Answer

A) 3 
B) 5 
C) 6 
D) 10 
A) 3 
B) 5 
C) 6 
D) 10

Question 12

Which macro feature is used to run a macro one step at a time to verify that arguments are correct and the macro runs appropriately?

Accepted Answer

A) Action Catalog 
B) Show All Actions 
C) single step mode 
D) all steps mode 
A) Action Catalog 
B) Show All Actions 
C) single step mode 
D) all steps mode

Question 13

An argument for the OpenTable action which specifies the view in which an object opens.

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 14

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 15

A database developer will usually want to prevent inexperienced users from deleting database records by creating a user interface that sets the Record Selectors property to No on an unbound form that allows the user to choose which query to run.____________________

Accepted Answer

A) True 
 B)False

Question 16

​Allows you to enter a lter term to lter the list of objects displayed in the Acton Catalog pane

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 17

The action that opens a specified form in a specified view.

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

​The instruction that initiates each individual command or keystroke within a macro

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 19

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 20

The action that moves the focus to a specified field or control on the active datasheet or form.

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

When Access opens a form or report,the ____ event occurs.

Single step mode remains on for all macros once it is turned on until it is manually turned off.

Using VBA code,a group of statements may be created that set the event property value to the name of that group of statements;Access will then execute an event ____ when the event occurs.

Opens a specied form in a specied view

To create a navigation form using the Navigation gallery,click on the ____ button on the Create tab.

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)<>"˜ ORDER BY[NAME];what does [TYPE]=5 indicate?

The default orientation for printing a report many be changed using the ____ feature of Access.

What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Executes one macro action at a time,pausing between actions

The action that selects a specified object and runs an action that applies to the object.

Access 2016 provides ____ predefined layouts for navigation forms with different layouts for the placement of tabs and subtabs.

Which macro feature is used to run a macro one step at a time to verify that arguments are correct and the macro runs appropriately?

An argument for the OpenTable action which specifies the view in which an object opens.

A database developer will usually want to prevent inexperienced users from deleting database records by creating a user interface that sets the Record Selectors property to No on an unbound form that allows the user to choose which query to run.____________________

Allows you to enter a lter term to lter the list of objects displayed in the Acton Catalog pane

The action that opens a specified form in a specified view.

The instruction that initiates each individual command or keystroke within a macro

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

The action that moves the focus to a specified field or control on the active datasheet or form.

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

When Access opens a form or report,the ____ event occurs.

Single step mode remains on for all macros once it is turned on until it is manually turned off.

Using VBA code,a group of statements may be created that set the event property value to the name of that group of statements;Access will then execute an event ____ when the event occurs.

​Opens a specied form in a specied view

To create a navigation form using the Navigation gallery,click on the ____ button on the Create tab.

In the SQL statement: SELECT [Name] FROM MSysObjects WHERE [TYPE]=5 AND Left([Name],1)<>"˜ ORDER BY[NAME];what does [TYPE]=5 indicate?

The default orientation for printing a report many be changed using the ____ feature of Access.

​What are some of the problems in restricting access to Database Objects and prohibiting design changes?

​Executes one macro action at a time,pausing between actions

The action that selects a specified object and runs an action that applies to the object.

Access 2016 provides ____ predefined layouts for navigation forms with different layouts for the placement of tabs and subtabs.

Which macro feature is used to run a macro one step at a time to verify that arguments are correct and the macro runs appropriately?

An argument for the OpenTable action which specifies the view in which an object opens.

A database developer will usually want to prevent inexperienced users from deleting database records by creating a user interface that sets the Record Selectors property to No on an unbound form that allows the user to choose which query to run.____________________

​Allows you to enter a lter term to lter the list of objects displayed in the Acton Catalog pane

The action that opens a specified form in a specified view.

​The instruction that initiates each individual command or keystroke within a macro

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

The action that moves the focus to a specified field or control on the active datasheet or form.

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

Opens a specied form in a specied view

What are some of the problems in restricting access to Database Objects and prohibiting design changes?

Executes one macro action at a time,pausing between actions

Allows you to enter a lter term to lter the list of objects displayed in the Acton Catalog pane

The instruction that initiates each individual command or keystroke within a macro