Microsoft Access: Creating a Lookup table (breaking a single table into two related tables)

In this short screencast we will examine the need to break a single table into two tables to solve a common problem: redundant data. Redundant data leads to data inaccuracies, inconsistencies, and unproductive data entry tasks.
To fix this problem, we will create a drop-down list of values for the field for the user to quickly and accurately select.
We will accomplish this by using a summary query, a Make Table query, and the Lookup Wizard.
This TH-cam is part of the "Lookup Tables and Lookup Fields" playlist.
See all of my TH-cams organized at learncs.w3spaces.com
Thank you,
Lisa Friedrichsen