Question 1

Match between columns
                        Premises: An argument for the OpenTable action which specifies the view in which an object opens.

Accepted Answer

The Answer of View Argument and SQL and WHERE and is...

Question 2

A user communicates with a computer program using a(n) ____________________.

Accepted Answer

The answer of A user communicates with a computer program...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

In the accompanying figure illustrating a SQL SELECT statement, the SELECT statement ends with a(n) ____.

Accepted Answer

A)  comma 
B)  period 
C)  semi-colon 
D)  equal symbol 
A)  comma 
B)  period 
C)  semi-colon 
D)  equal symbol

Question 5

Access 2013 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 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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 11

In the accompanying figure, which numbered arrow indicates the event to which a submacro has been assigned as a property?

Accepted Answer

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

Question 12

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

Question 13

Case-Based Critical Thinking Questions Case 10-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 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 14

Match between columns
                        Premises: A SQL keyword after which selection criteria is listed in a SQL SELECT statement.

Accepted Answer

The Answer of GoToControl and message box and RunMenuCommand and is...

Question 15

Match between columns
                        Premises: The action that selects a specified object and runs an action that applies to the object.

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

A user communicates with a computer program using a(n) ____________________.

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

In the accompanying figure illustrating a SQL SELECT statement, the SELECT statement ends with a(n) ____.

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

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

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

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

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

Which of the following describe the five SQL statement types?

In the accompanying figure, which numbered arrow indicates the event to which a submacro has been assigned as a property?

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

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

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

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

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

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

A user communicates with a computer program using a(n) ____________________.

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

In the accompanying figure illustrating a SQL SELECT statement, the SELECT statement ends with a(n) ____.

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

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

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

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

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

Which of the following describe the five SQL statement types?

In the accompanying figure, which numbered arrow indicates the event to which a submacro has been assigned as a property?

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

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

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

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

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

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