[ Team LiB ] Previous Section Next Section

Workshop

The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.

Quiz

1:

When sorting a query, the field order on the query grid is important (True/False).

A1:

True.

2:

You can always update a query result (True/False).

A2:

False. In certain conditions, fields, or possibly the entire query result, may not be updateable.

3:

What expression would you use to find all records with sales at the beginning of the field?

A3:

Like Sales*.

4:

What expression would you use to find all records with the values 5 through 10, inclusive, in a field?

A4:

Between 5 and 10.

5:

What expression would you use to find all records in NV, CA, and UT?

A5:

"NV" or "CA" or "UT". You could also use In("NV", "CA", "UT").

Activities

Practice building several single-table and multitable queries, using your own data. Practice sorting the query results as well as entering various criteria. Also practice updating the query results. Finally, practice using the Expression Builder to build some date/time expressions.

    [ Team LiB ] Previous Section Next Section