Question 1

Click the VIEW tab on the ribbon to create a backup. ____________________

Accepted Answer

A) True 
 B)False

Question 2

In the figure above, how will the records be presented?

Accepted Answer

A)  Smallest to largest by count of EnrollmentID 
B)  Largest to smallest by count of EnrollmentID 
C)  Smallest to largest group by Description 
D)  Largest to smallest group by Description 
A)  Smallest to largest by count of EnrollmentID 
B)  Largest to smallest by count of EnrollmentID 
C)  Smallest to largest group by Description 
D)  Largest to smallest group by Description

Question 3

In Query Design View, the asterisk in the field list represents all the fields in the table.

Accepted Answer

A) True 
 B)False

Question 4

Double-clicking an action query in the Navigation Pane runs the query.

Accepted Answer

A) True 
 B)False

Question 5

The Top Values feature creates summarized calculations on groups of records.

Accepted Answer

A) True 
 B)False

Question 6

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

Accepted Answer

A) True 
 B)False

Question 7

In the figure above, what Top Values option is chosen?

Accepted Answer

A)  Top 5 
B)  Top 100 
C)  Top 5% 
D)  All 
A)  Top 5 
B)  Top 100 
C)  Top 5% 
D)  All

Question 8

In the figure above, which field is being grouped?

Accepted Answer

A)  Enrollments 
B)  EnrollmentID 
C)  Description 
D)  CourseID 
A)  Enrollments 
B)  EnrollmentID 
C)  Description 
D)  CourseID

Question 9

In Query Design View, double-click the _________________________ at the top of a table's field list to quickly add all fields within the table to the query design grid.

Accepted Answer

The answer of In Query Design View, double-click the _________________________...

Question 10

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

Accepted Answer

The answer of When you click the Delete button from...

Question 11

In the figure above, what does item 3 refer to?

Accepted Answer

A)  Count of EnrollmentID field 
B)  Sum of EnrollmentID field 
C)  Subtotal of records with numeric values 
D)  Total of EnrollmentID field 
A)  Count of EnrollmentID field 
B)  Sum of EnrollmentID field 
C)  Subtotal of records with numeric values 
D)  Total of EnrollmentID field

Question 12

In the figure above, item 4 refers to the ____ query icon.

Accepted Answer

A)  Append 
B)  Delete 
C)  Make Table 
D)  Update 
A)  Append 
B)  Delete 
C)  Make Table 
D)  Update

Question 13

Parameter criteria are always entered within ____.

Accepted Answer

A)  (Parentheses) 
B)  {Curly brackets} 
C)  [Square brackets] 
D) . 
A)  (Parentheses) 
B)  {Curly brackets} 
C)  [Square brackets] 
D) .

Question 14

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

Accepted Answer

A) True 
 B)False

Question 15

The ____ entry in the Recordset Type property locks the recordset.

Accepted Answer

A)  Snapshot 
B)  Dynaset 
C)  Dataset 
D)  Lockset 
A)  Snapshot 
B)  Dynaset 
C)  Dataset 
D)  Lockset

Question 16

The Description property appears on the Database Documenter reports. ____________________

Accepted Answer

A) True 
 B)False

Question 17

If you modify a field's properties in Table Design View, they are modified for the entire database.

Accepted Answer

A) True 
 B)False

Question 18

When building an action query, data will not be changed until you click the ____ button.

Accepted Answer

A)  Datasheet 
B)  Query Type 
C)  Run 
D)  Update 
A)  Datasheet 
B)  Query Type 
C)  Run 
D)  Update

Question 19

Items 3 through 7 shown in the figure above are Query _________________________ buttons displayed on the DESIGN tab.

Accepted Answer

The answer of   Items 3 through 7 shown...

Question 20

In the figure above, item 1 refers to which feature?

Accepted Answer

A)  Group By 
B)  Totals 
C)  Top Values 
D)  Query Type 
A)  Group By 
B)  Totals 
C)  Top Values 
D)  Query Type

Click the VIEW tab on the ribbon to create a backup. ____________________

In the figure above, how will the records be presented?

In Query Design View, the asterisk in the field list represents all the fields in the table.

Double-clicking an action query in the Navigation Pane runs the query.

The Top Values feature creates summarized calculations on groups of records.

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

In the figure above, what Top Values option is chosen?

In the figure above, which field is being grouped?

In Query Design View, double-click the _________________________ at the top of a table's field list to quickly add all fields within the table to the query design grid.

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

In the figure above, what does item 3 refer to?

In the figure above, item 4 refers to the ____ query icon.

Parameter criteria are always entered within ____.

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

The ____ entry in the Recordset Type property locks the recordset.

The Description property appears on the Database Documenter reports. ____________________

If you modify a field's properties in Table Design View, they are modified for the entire database.

When building an action query, data will not be changed until you click the ____ button.

Items 3 through 7 shown in the figure above are Query _________________________ buttons displayed on the DESIGN tab.

In the figure above, item 1 refers to which feature?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 11: Creating Advanced Queries

Click the VIEW tab on the ribbon to create a backup. ____________________

In the figure above, how will the records be presented?

In Query Design View, the asterisk in the field list represents all the fields in the table.

Double-clicking an action query in the Navigation Pane runs the query.

The Top Values feature creates summarized calculations on groups of records.

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

In the figure above, what Top Values option is chosen?

In the figure above, which field is being grouped?

In Query Design View, double-click the _________________________ at the top of a table's field list to quickly add all fields within the table to the query design grid.

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

In the figure above, what does item 3 refer to?

In the figure above, item 4 refers to the ____ query icon.

Parameter criteria are always entered within ____.

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

The ____ entry in the Recordset Type property locks the recordset.

The Description property appears on the Database Documenter reports. ____________________

If you modify a field's properties in Table Design View, they are modified for the entire database.

When building an action query, data will not be changed until you click the ____ button.

Items 3 through 7 shown in the figure above are Query _________________________ buttons displayed on the DESIGN tab.

In the figure above, item 1 refers to which feature?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters