Page 10 of 11PREVNEXT

Design tables for a new Access 2007 database

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

What is the function of a primary key?

To uniquely identify each record in a table.

To encrypt and decrypt your database.

To help ensure you enter data in the correct table.

A good database design helps ensure that your data is:

Always backed up.

Complete and accurate.

Duplicated so it's easier to find.

You should always place all your data in separate tables.



How many tables should a well-designed database contain?

As many as necessary to capture all your data without redundancy.

One, with many fields.


You establish a relationship between Table A and Table B by:

Merging Table A with Table B.

Linking Table A with Table B.

Adding the primary key from Table A to Table B (or vice-versa).

Page 10 of 11PREVNEXT