Student Resources: Lesson Quizzes

Lesson 5: Managing Data Integrity

	1.	A link or connection between two tables sharing a common field is called a

		a.	Database rule
		b.	Lookup field
		c.	Relationship
		d.	Record

	2.	A foreign key field is the field that refers to the primary key field in a related table.

		a.	TRUE
		b.	FALSE

	3.	If the common fields in both the first and the second tables are primary keys, the relationship is a One-To-Many relationship.

		a.	TRUE
		b.	FALSE

	4.	What term refers to a field property that displays a pattern for entering data?

		a.	Default value
		b.	Format
		c.	Input mask
		d.	Subdatasheet

	5.	A lookup field ensures accuracy and consistency because the user can only select a value from a predefined list.

		a.	TRUE
		b.	FALSE