FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 16: Access: Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

To show the Navigation Pane if it is hidden,click the ____ Button.

A) Show
B) Shutter Bar Open/Close
C) Restore
D) Show/Hide

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

To find all customers whose names begin with Sr,enter ____________________ as the criterion for the Customer Name field.

Correct Answer

verified

Sr*

Question 3

Short Answer

Review LaterAdd Note

The type of join that finds records from both tables that have identical values in matching fields is called a(n)____________________ join.

Wildcards are symbols that represent any character or combination of characters.____________________

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

To change the caption for a field in a query,click the field in the design grid,click the ____ button on the Design tab,click the Caption box,and enter the new caption.

The ____________________ wildcard represents any collection of characters.

-The accompanying figure illustrates using a query to ____ tables;that is,to find records in two tables that have identical values in matching fields.

To sort records by amount paid within book rep number,specify Book Rep Number as the ____________________ key.

A(n)____________________ function is a function that performs some mathematical function against a group of records.

-In the accompanying figure,the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

To display the entire entry for a calculated field,select the column in the Field row,right-click to display the shortcut menu,and then click ____.

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

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

To save a query,tap or click the Save button on the ____.

You can include ____ in calculations to indicate which calculation should be done first.

Case 2-2 Bavant Publishing needs to find the book reps whose start date is earlier than 1/1/2013. -The caption for the Start Date field should be Started when the query results display.How can Bavant change the caption?

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

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

If the criterion for Current Due field is 0,the query results for this query will display ____ in the Current Due field.