Access 2010: Chapter 2 – Multiple Choice
1. When you use ____, usually you are looking for those records that satisfy some criterion.
2. The ____ wildcard symbol represents any individual character.
b. exclamation point
c. question mark
3. Unless you specify otherwise, Access assumes that the criteria you enter involve ____.
4. Often you will have more than one criterion that the data for which you are searching must satisfy. This type of criterion is called a ____ criterion.
5. In a(n) ____ criterion, each individual criterion must be true in order for the compound criterion to be true.
6. If you want to create a criterion involving a range of values in a single field, you can use the ____ operator.
7. To order the records in a query result in a particular way, you ____ the records.
8. A property sheet is a window containing the various properties of the object. To omit duplicates, you will use the property sheet to change the Unique Values property from ____.
a. Yes to No
b. No to Yes
c. True to False
d. False to True
9. Common delimiters include all of the following EXCEPT ____.
10. ____ means creating groups of records that share some common characteristic.