Student Resources: Lesson Quizzes

Lesson 3: Finding and Sorting Records

	1.	What Find and Replace dialog box option finds records in which the beginning of a field matches the Find What entry?

		a.	Match: Any Part of Field
		b.	Match: Start of Field
		c.	Match: Whole Field
		d.	Search: All

	2.	Wildcards are text strings or expressions that Access uses to find matching records.

		a.	TRUE
		b.	FALSE

	3.	You can use the Replace command by pressing

		a.	Alt + H
		b.	Ctrl + H
		c.	Ctrl + Alt + H
		d.	Ctrl + Shift + H

	4.	The primary key is a field in which data is unique for every record.

		a.	TRUE
		b.	FALSE

	5.	What type of filter displays records that match a keyed value?

		a.	Filter By Form
		b.	Filter By Input
		c.	Filter By Selection
		d.	Filter Excluding Selection