Access 2016 provides a Lookup Wizard that makes it easy to create lookup tables.
A lookup table is a table that contains data that is referenced by another table. The other table will have a lookup field that can "lookup" the data in the lookup table.
In Access, the lookup field displays the data as a drop down list (or combo box) so that the user can select the desired value from the list. The values of the lookup field come directly from the lookup table.
We will now turn our Genres table into a lookup table. The Albums table will then have a lookup field that gets its values from the Genre table.