Add a Multiple Check List to your MS Access Database

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

Nifty Access YouTube Thumb Nail
Play Video

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

Nifty Access YouTube Thumb Nail
Play Video

3 - Adding Multiple Checklists to MS Access

Adding Multiple Checklists

Video 3 - 2:37 min

Video 3 - 2:37 min

Nifty Access YouTube Thumb Nail
Play Video

4 - Adding Multiple Checklists to MS Access

Adding Multiple Checklists

Video 4 - 4:53 min

Video 4 - 4:53 min

Nifty Access YouTube Thumb Nail
Play Video

5 - Adding Multiple Checklists to MS Access

Adding Multiple Checklists

Video 5 - 7:14 min

Video 5 - 7:14 min

Nifty Access YouTube Thumb Nail
Play Video

6 - Adding Multiple Checklists to MS Access

Adding Multiple Checklists

 Video 6 - 2:45 min

 Video 6 - 2:45 min

Nifty Access YouTube Thumb Nail
Play Video

Do you need a hand in the right direction?

You are in the right place.