Question 1

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

Accepted Answer

A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query 
A)  Query 
B)  Design View 
C)  Query Design 
D)  Select Query

Question 2

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

Accepted Answer

A)  Objects by Table 
B)  Table Object 
C)  Tables and Related Views 
D)  Default 
A)  Objects by Table 
B)  Table Object 
C)  Tables and Related Views 
D)  Default

Question 3

Critical Thinking Questions 
Case 2-2 
PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. 
The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

Accepted Answer

Click the Start Date field in the design

Question 4

You cannot create a report for a query.

Accepted Answer

A) True 
 B)False

Question 5

The ____ operator allows you to search for a range of values in one field.

Accepted Answer

A)  BETWEEN 
B)  RANGE 
C)  IN 
D)  SEARCH 
A)  BETWEEN 
B)  RANGE 
C)  IN 
D)  SEARCH

Question 6

To order the records in the answer to a query in a particular way, you ____ the records.

Accepted Answer

A)  index 
B)  sort 
C)  arrange 
D)  list 
A)  index 
B)  sort 
C)  arrange 
D)  list

Question 7

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

Accepted Answer

A)  DATABASE TOOLS 
B)  EXTERNAL DATA 
C)  OFFICE EXPORT 
D)  CREATE 
A)  DATABASE TOOLS 
B)  EXTERNAL DATA 
C)  OFFICE EXPORT 
D)  CREATE

Question 8

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

Accepted Answer

A)  curly braces { } 
B)  square brackets [ ] 
C)  parentheses ( ) 
D)  single quotes '' 
A)  curly braces { } 
B)  square brackets [ ] 
C)  parentheses ( ) 
D)  single quotes ''

Question 9

A(n) ____________________ is a window containing the various properties of the object.

Accepted Answer

The answer of A(n) ____________________ is a window containing the...

Question 10

The special criteria that can be used in queries are ____.

Accepted Answer

A)  AND 
B)  INCLUSIVE 
C)  BETWEEN 
D)  IN 
A)  AND 
B)  INCLUSIVE 
C)  BETWEEN 
D)  IN

Question 11

Crosstab queries are useful for summarizing data by category or group.

Accepted Answer

A) True 
 B)False

Question 12

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

Accepted Answer

A)  Large 
B)  Maximum 
C)  LGE 
D)  MAX 
A)  Large 
B)  Maximum 
C)  LGE 
D)  MAX

Question 13

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

Accepted Answer

A) True 
 B)False

Question 14

The question mark (?) wildcard represents any collection of characters.

Accepted Answer

A) True 
 B)False

Question 15

The ____________________ function finds the smallest value in a group of records.

Accepted Answer

The answer of The ____________________ function finds the smallest value...

Question 16

To enter a number in a criterion, type the number without any dollar signs or commas.

Accepted Answer

A) True 
 B)False

Question 17

A question that is asked of Access or any other database management system is called a(n) ____________________.

Accepted Answer

The answer of A question that is asked of Access...

Question 18

The results of a query display in ____________________ view.

Accepted Answer

The answer of The results of a query display in...

Question 19

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

Accepted Answer

A) True 
 B)False

Question 20

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

Accepted Answer

A)  No 
B)  Yes 
C)  Off 
D)  On 
A)  No 
B)  Yes 
C)  Off 
D)  On

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

Critical Thinking Questions Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

You cannot create a report for a query.

The ____ operator allows you to search for a range of values in one field.

To order the records in the answer to a query in a particular way, you ____ the records.

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

A(n) ____________________ is a window containing the various properties of the object.

The special criteria that can be used in queries are ____.

Crosstab queries are useful for summarizing data by category or group.

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

The question mark (?) wildcard represents any collection of characters.

The ____________________ function finds the smallest value in a group of records.

To enter a number in a criterion, type the number without any dollar signs or commas.

A question that is asked of Access or any other database management system is called a(n) ____________________.

The results of a query display in ____________________ view.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

Access 1 Databases and Database Objects: an Introduction

Excel 1 Creating a Worksheet and a Chart

Excel 2 Formulas, Functions, and Formatting

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

Word 1 Creating, Formatting, and Editing a Word Document With a Picture

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters

Exam 2: Access 2 Querying a Database

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

Critical Thinking Questions Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

You cannot create a report for a query.

The ____ operator allows you to search for a range of values in one field.

To order the records in the answer to a query in a particular way, you ____ the records.

To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

A(n) ____________________ is a window containing the various properties of the object.

The special criteria that can be used in queries are ____.

Crosstab queries are useful for summarizing data by category or group.

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

The question mark (?) wildcard represents any collection of characters.

The ____________________ function finds the smallest value in a group of records.

To enter a number in a criterion, type the number without any dollar signs or commas.

A question that is asked of Access or any other database management system is called a(n) ____________________.

The results of a query display in ____________________ view.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

Access 1 Databases and Database Objects: an Introduction

Excel 1 Creating a Worksheet and a Chart

Excel 2 Formulas, Functions, and Formatting

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

Word 1 Creating, Formatting, and Editing a Word Document With a Picture

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters