Workshop

The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.

Quiz

1:	Name three types of relationships.
A1:	One-to-many, one-to-one, and many-to-many.
2:	Name the types of relationship that you cannot directly create in Access.
A2:	Many-to-many.
3:	Name the three attributes that constitute a good primary key.
A3:	Minimal, stable, and simple.
4:	Denormalization slows down performance (True/False).
A4:	False. The primary reason for denormalization is generally to improve performance.
5:	The Relationships window always reflects the relationships that are in place in a database (True/False).
A5:	False. The Relationships window provides a visual layout of the relationships that are included within the window. This may or may not represent all the relationships in the database.

Activities

Build three related tables. Don't forget to set their primary keys. Establish relationships between them. Set referential integrity. Attempt to add, remove, and modify data. Practice using the Cascade Update Related Fields and Cascade Delete Related Fields options. See how this affects the process of inserting, updating, and deleting data.