Multiple Checklists
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”
Video 2 - 5:47 min
…
3 - Adding Multiple Checklists to MS Access
Adding Multiple Checklists
Video 3 - 2:37 min
Video 3 - 2:37 min
…
4 - Adding Multiple Checklists to MS Access
Adding Multiple Checklists
Video 4 - 4:53 min
Video 4 - 4:53 min
…
5 - Adding Multiple Checklists to MS Access
Adding Multiple Checklists
Video 5 - 7:14 min
Video 5 - 7:14 min
…
6 - Adding Multiple Checklists to MS Access
Adding Multiple Checklists
Video 6 - 2:45 min
Video 6 - 2:45 min
…
