Multiple Choice Quiz

Click on the correct response for each question below.

1		This operator is assumed when you enter criteria in multiple fields.
			A)	A. AND
			B)	B. IF
			C)	C. OR
			D)	D. THEN
2		This is a request for specific data contained in a database.
			A)	A. Count
			B)	B. Criteria
			C)	C. Filter
			D)	D. Sort
3		Queries are not used for
			A)	A. Viewing data in different ways.
			B)	B. Creating new data.
			C)	C. Analyzing data.
			D)	D. Changing existing data.
4		Queries are based on this, allowing you to use a query as the source for forms and reports.
			A)	A. Filters
			B)	B. Tables
			C)	C. Records
			D)	D. Fields
5		This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
			A)	A. Crosstab
			B)	B. Columnar
			C)	C. Select
			D)	D. Action
6		Which of the following is not one of the methods available in the New Query dialog box to create queries?
			A)	A. Design View
			B)	B. Crosstab Query Wizard
			C)	C. Simple Query Wizard
			D)	D. Datasheet View
7		This query wizard will create a select query.
			A)	A. Crosstab
			B)	B. Find Duplicates
			C)	C. Simple
			D)	D. Design View
8		This query wizard will locate records in one table that do not have records in another.
			A)	A. Find Unmatched
			B)	B. Find Duplicates
			C)	C. Simple
			D)	D. Crosstab
9		The quickest way to add a field to the Selected Fields list is to double-click its field name in this list.
			A)	A. Find Fields
			B)	B. Search Fields
			C)	C. Search Record
			D)	D. Available Fields
10		The result of a query is displayed in a
			A)	A. Record.
			B)	B. Query datasheet.
			C)	C. Query table.
			D)	D. Form.
11		Changing the order of this in the query datasheet does not affect the field order in the table.
			A)	A. Record
			B)	B. Row
			C)	C. Column
			D)	D. Sort