Q: Structure and relationship of tables

[lovedieer]

I am totally a first time user for Access. I need to build a review database for several nursing homes.

Project description:

My company will do review for persons live in nursing home. The data review manager need to enter each person's Demographic information such as: Name, ssn, address..., they also need to answer 20 survey questions (yes/no) related to their service. if the answer is no, they need do the remediation for the people they served. The remediation include: What's the error, what remediation to be taken and remediation CLosure Date.


Basically, I build one table called Demo, which include all person's demographic information (ParticipantID, FirstName,.......),
one table called question, which include (questionID, QuestionDescription)
ONe table called remediation (I am lost here, do I need to put "Error found" , "remediation" and "closedate" as different column or put them in same column)
I think I need one more table to put everything together, but I am not sure how to do it.

The other thing is how do i related these tables.

Any help will be appreciated.
Thanks.

 

[Fifty2One]

probably a good way to have it would be a table for the demographics and a second one for this particular survey and a third for the Error, Remediation and Closure - they will probably after the fact ask for the initiation date for the Error and Remediation as well as the Closure date.
In all three tables you would need a uniquifier so you can link the tables together - patient number or similar.