Page 10 of 11PREVNEXT

Queries III: Use expressions and other criteria

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


You want to find out the 10 students with the lowest grades, so you:

Average all the scores and then compare the scores to the average.

Use the Low Values function.

Use a Bottom Values query.

In a query, you surround dates with _____.

Quotation marks.

Brackets.

Number signs (#).

What will the following expression find?

Between 10 And 20

All records whose values are between 10 and 20, including 10 and 20.

All records whose values are between 10 and 20, but not including 10 and 20.

All records that contain 10 and 20.

An expression consists of _____.

Values such as text or numbers, functions, and mathematical operators such as greater-than signs.

Data types, table fields, and comparison operators.

Comparison operators, double-quotes, and the Show check box.

Page 10 of 11PREVNEXT