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

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.