Question 1

This kind of operator selects all records between 2 specified values.

Accepted Answer

A)  Find Unmatched 
B)  Make Table 
C)  Between...And 
D)  Yes/No 
A)  Find Unmatched 
B)  Make Table 
C)  Between...And 
D)  Yes/No

Question 2

List the four types of action queries and give an example of what each would do.

Accepted Answer

1. A Delete query would be created to re

Question 3

-In the figure above, the parameter criteria is ____.

Accepted Answer

A)  Descending 
B)  Group By 
C)  5 
D)  There is no parameter criteria in the figure. 
A)  Descending 
B)  Group By 
C)  5 
D)  There is no parameter criteria in the figure.

Question 4

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

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

Accepted Answer

duplicates

Question 6

Match each term with the best choice.
-Adds a group of records from one or more tables to another table

Accepted Answer

A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query 
A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query

Question 7

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

Accepted Answer

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

Question 8

Action queries select but do not change data.

Accepted Answer

A) True 
 B)False

Question 9

Explain what a parameter query does.

Accepted Answer

A parameter query displays a dialog box

Question 10

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

Accepted Answer

A) True 
 B)False

Question 11

-Refer to the figure above. Describe what you would do to show all of the records in the Courses table even if there were no related Enrollments records.

Accepted Answer

Click opti

Question 12

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

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

Which action query would you use if you wanted to export records to another Access database?

Accepted Answer

A)  Make-Table 
B)  Top Values 
C)  Update 
D)  Delete 
A)  Make-Table 
B)  Top Values 
C)  Update 
D)  Delete

Question 16

Match each term with the best choice.
-Removes a group of records from one or more tables

Accepted Answer

A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query 
A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query

Question 17

-In the figure above, which field is being counted?

Accepted Answer

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

Question 18

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

Question 19

Which button do you use to complete an action query?

Accepted Answer

A)  View 
B)  Select 
C)  Show 
D)  Run 
A)  View 
B)  Select 
C)  Show 
D)  Run

Question 20

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

Accepted Answer

A) True 
 B)False

This kind of operator selects all records between 2 specified values.

List the four types of action queries and give an example of what each would do.

-In the figure above, the parameter criteria is ____.

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

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

Match each term with the best choice. -Adds a group of records from one or more tables to another table

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

Action queries select but do not change data.

Explain what a parameter query does.

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

-Refer to the figure above. Describe what you would do to show all of the records in the Courses table even if there were no related Enrollments records.

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

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

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

Which action query would you use if you wanted to export records to another Access database?

Match each term with the best choice. -Removes a group of records from one or more tables

-In the figure above, which field is being counted?

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

Which button do you use to complete an action query?

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 12: Creating Advanced Queries

This kind of operator selects all records between 2 specified values.

List the four types of action queries and give an example of what each would do.

-In the figure above, the parameter criteria is ____.

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

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

Match each term with the best choice. -Adds a group of records from one or more tables to another table

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

Action queries select but do not change data.

Explain what a parameter query does.

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

-Refer to the figure above. Describe what you would do to show all of the records in the Courses table even if there were no related Enrollments records.

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

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

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

Which action query would you use if you wanted to export records to another Access database?

Match each term with the best choice. -Removes a group of records from one or more tables

-In the figure above, which field is being counted?

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

Which button do you use to complete an action query?

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters