Lesson 05 Quiz


1	A relationship is created between how many tables?
	A)	One
	B)	Two
	C)	Three
	D)	Any number



2	Relationships change a flat database, containing isolated data, into a relational database, containing _______________ data.
	A)	disjoined
	B)	like
	C)	linked
	D)	foreign



3	What type of relationship is created when you select a primary key in both related tables?
	A)	One-To-One
	B)	Indeterminate
	C)	One-To-Many
	D)	Many-To-Many



4	You can create a Relationships Report from the _______________ tab.
	A)	Home
	B)	Create
	C)	Design
	D)	File



5	When referential integrity is enforced, an _____________ symbol displays on the "many" side.
	A)	1
	B)	M
	C)	asterisk
	D)	infinity



6	Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
	A)	queries
	B)	fields
	C)	records
	D)	tables



7	Which dialog box is accessed to enforce referential integrity in a One-To-Many relationship?
	A)	Change Input Mask
	B)	Edit Relationships
	C)	Insert Subdatasheet
	D)	Show Tables



8	A(n) _______________ is a datasheet nested within another datasheet that contains data related or joined to the first datasheet.
	A)	object dependency
	B)	relationship
	C)	report
	D)	subdatasheet



9	Data stored as a(n) _______________ data type takes up less space than if stored as a text data type.
	A)	number
	B)	field
	C)	calendar
	D)	primary key



10	How does understanding object dependency ensure data integrity?
	A)	By providing a predefined list of values to choose from.
	B)	By creating a primary key for all tables.
	C)	By preventing users from deleting required database objects.
	D)	By creating validation rules.

Notes		(What is this?)

Add a note
1.	(optional) Enter a note here:
2.	(optional) Select some text on the page (or do this before you open the "Notes" drawer).
3.	Highlighter Color:
4.

Home > Access > Lesson 05 Quiz