1. Which are
rules for Normalizing a Database? (Give all correct answers.)
A. Minimize duplicate data
B. Protect data integrity
Tip: Advanced Access, page 68
2. Second Normal Form is less restrictive than First Normal Form.
A. True
B. False
Tip: Advanced Access, page 70
3. Third Normal Form uses only Primary and Foreign Keys to create
relationships.
A. True
B. False
Tip: Advanced Access, page 72
4. Which of
the following are shown with the Relationship Command?
(Give all
correct answers.)
A. Tables joined by a common Key field
B. Queries that have relationships creating using the Join command
Tip: Advanced Access, page 76, 77
5. Which is true about Referential Integrity?
(Give all
correct answers.)
A. Aims to prevent widow or orphan Records
B. Uses the Cascade Related Fields commands to update or delete matching
records on all Joined Tables
Tip: Advanced Access, page 81
