FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Access 2 Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Essay

Review LaterAdd Note

Review Later

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?

Correct Answer

verified

Click the Start Date field in the design...

View Answer

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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) curly braces { }
B) square brackets [ ]
C) parentheses ( )
D) single quotes ''

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

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

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

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

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 restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

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

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

The results of a query display in ____________________ view.

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

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

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

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

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

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

You cannot create a report for a query.

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.