FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 61

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Enlarge
B) Resize
C) Magnify
D) Zoom

E) C) and D)
F) A) and B)

Correct Answer

verified

Show Answer

Question 62

Multiple Choice

Review LaterAdd Note

Review Later

In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $2,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.

A) =2,000
B) 2,000
C) =$2,000
D) 2000

E) A) and B)
F) B) and C)

Correct Answer

verified

Show Answer

Question 63

Multiple Choice

Review LaterAdd Note

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

Less than ( ) , and NOT (not equal to) are examples of _____.

When you create a query, you should follow some general guidelines for query design. What are these six guidelines?

The ____________________ is an Access tool that helps you create complex expressions.

Which aggregate function will find the client with the smallest amount paid?

In the accompanying figure, you can enter BC76 in the ____ row of the Client Number field to find all clients whose client number is BC7 6)

A property sheet is a window containing the various properties of the object.

The ____________________ wildcard represents any collection of characters.

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

If a Security Warning appears when you open an Access database, click the option ____________________ button.