You will review the importance of referential integrity when creating relationships in Access.  Then you will learn a second way of creating relationships between tables that makes data entry much more efficient and accurate. The Lookup Wizard method will create a relationship between two tables, and it will also provide the user with a drop-down list from which to select the correct entry.

You will learn how to modify a database relationship to a Lookup, and will also learn how to create a Lookup from the start.