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