1. Which of the following is NOT a principle of relational database design?

a.	Design each table to contain fields that describe only one subject.
b.	Identify a primary key field or key field combination for each table.
c.	Data should be entered before table relationships are built.
d.	Build one-to-many relationships between the tables of your database using a field common to each table.

1. A relational database can best be described as a collection of related ____ designed to minimize redundant data.

a.	Indexes	c.	Links
b.	Tables	d.	Properties

1. A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

a.	Primary	c.	Foreign
b.	First	d.	Infinity

1. Where do you modify field properties?

a.	In Table Datasheet View
b.	In Table Design View
c.	In Database Design View
d.	As you are entering data in a form

1. The ____ property provides a label used to describe the field.

a.	Format	c.	Mask
b.	Caption	d.	Default

1. Which Text field property would you use to specify whether an entry was required for the field?

a.	Default Value	c.	Required
b.	Default	d.	Test

1. An SQL statement determines what fields are selected after the ____ keyword.

a.	SELECT	c.	ORDER BY
b.	FROM	d.	LIST

1. An SQL statement determines how the tables are joined after the ____ keyword

a.	SELECT	c.	FROM
b.	RELATE	d.	ORDER BY

1. If referential integrity is applied to a one-to-many relationship, what happens?

a.	Connects tables	c.	Related fields are updated
b.	Prevents the creation of orphan records	d.	Related fields are deleted

1. Cascade Delete Related Records automatically deletes all records in ____ if the record with the matching key field in a one table is deleted.

a.	The many table	c.	The database
b.	Another one table	d.	The primary key field

1. ____ makes a duplicate copy of the data in the Access database.

a.	Linking	c.	Compacting
b.	Importing	d.	Indexing

1. A feature called ____ helps you copy information from Excel to Access.

a.	Shortcut	c.	Import Spreadsheet Wizard
b.	Table Template	d.	Mail Merge Task Pane

1. Once a linked table is related to other objects in a database, it can be a part of ____ that use fields from multiple tables.

a.	Forms	c.	Neither A nor B
b.	Queries	d.	Both A and B

1. Which of the following is NOT a source from which Access can import data?

a.	Excel	c.	HTML
b.	Outlook folder	d.	PDF