Add a Multiple Check List to your MS Access Database

This set of videos I expand on the idea presented in the “Single Checklist” videos. I recommend you watch the “Single Checklist” videos before you start creating
“Multiple Checklists”. You will need to be able to set up a “Single Checklist” before you embark on the task of setting up “Multiple Checklists”.

Create LookUp Table

Overview of the finished Product

Video 1 - 5:20 min

Here, I explain how you can examine your imported data to identify data that should be converted into lookup tables I demonstrate how to convert this data into lookup tables.

Video 1 - 5:20 min

Multiple Checklists - Add LookUp

Adding Multiple Checklists

Video 2 - 5:47 min

In this video I demonstrate how to change a text entry into a number which reference’s a lookup table. You do this by adding an extra field to the table with the text entry. This extra field receives the lookup value. You fill this field, using an update query. Then you remove the original text field and rename the new number field to take its place. At the end of this video you have correctly set up table where the text has been replaced with a lookup value. The lookup values are now stored in a table called “table lookup” >>> “tblLookUp”