Access 2010: Chapter 2 Multiple Choice

 

1.     When you use ____, usually you are looking for those records that satisfy some criterion.

a.      statistics

b.     forms

c.      datasheets

d.     queries

 

2.     The ____ wildcard symbol represents any individual character.

a.      comma

b.     exclamation point

c.      question mark

d.     asterisk

 

3.     Unless you specify otherwise, Access assumes that the criteria you enter involve ____.

a.      simplicity

b.     complexity

c.      inequality

d.     equality

 

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.

a.      compound

b.     common

c.      complex

d.     combination

 

5.     In a(n) ____ criterion, each individual criterion must be true in order for the compound criterion to be true.

a.      OR

b.     AND

c.      BEWEEN

d.     IN

 

6. If you want to create a criterion involving a range of values in a single field, you can use the ____ operator.

a.      OR

b.     AND

c.      BETWEEN

d.     IN

 

7. To order the records in a query result in a particular way, you ____ the records.

a.      sort

b.     report

c.      prioritize

d.     process

 

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

a.      tags

b.     semicolons

c.      commas

d.     spaces

 

10. ____ means creating groups of records that share some common characteristic.

a.      Ordering

b.     Restoring

c.      Grouping

d.     Dividing