Help designing a checklist in access

[silversubey]

Hello All

My company currently uses excel checklists to ensure that projects are
completed fully. we have around 10 different checklists. each
checklist (excel file) has 6 sheets, each sheet 15 questions or steps.
most answers are Y,N,NA and the employees put their initials in the
correct answer column. Many questions are redundant throughout the 10
checklists. I would like to create the checklists in access because
their are too many excel files getting lost and if we change question/
step. we have to change it multiple times. the employees need to enter
a clients name and then choose the checklist. projects can take weeks
to complete so when a checklist is chosen the steps that have already
been completed need to be there. I have searched the internet and
found some help but I can't make sense of it. the following is what I
have so far.

Table-Checklists
pk-checklistID (auto#)
checklist_type (name of chcklist)

Table- Questions
pk QstnID (auto#)
chklstID (links to checklsts table)
Qstntext (Question text)

Table- Answers
Answid
QstnID(id from questions id)
respns(ID from Clients table)

Clients
pk-ClientID
client_name

I hope this makes sense. Any help is greatly appreciated

Thankyou

 

[Jeff Boyce]

What you describe sounds similar to a "survey". Duane H. has created a
sample database designed specifically to help you build surveys and
questionnaires:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Office/Access MVP