Q
Questionnaire response database question
I have made a questionnaire database using the nonrelational table approach.
However, I found it troublesome in adding new questions to it. What I am
thinking is to restructure it to a relational database.
I need to capture responses from employees from a list of different
companies. There is a total of 50 questions. Each company only wants their
employees to answer some of the questions. For instance, Company A might
only want their employees to answer question 1 to 20. The challenge for me
in using a relational database is that when I open up the form, I want the
questions chosen by each companies to appear automatically instead of having
to "choose the question from a drop box every time."
When I look at the link
http://support.microsoft.com/default.aspx?scid=kb;en-us;101675, the example
only tells me how to switch data from an old database to a new one. I need
to know exactly how to design it as a relational database right from the
beginning. Thanks for everyone that would respond.
However, I found it troublesome in adding new questions to it. What I am
thinking is to restructure it to a relational database.
I need to capture responses from employees from a list of different
companies. There is a total of 50 questions. Each company only wants their
employees to answer some of the questions. For instance, Company A might
only want their employees to answer question 1 to 20. The challenge for me
in using a relational database is that when I open up the form, I want the
questions chosen by each companies to appear automatically instead of having
to "choose the question from a drop box every time."
When I look at the link
http://support.microsoft.com/default.aspx?scid=kb;en-us;101675, the example
only tells me how to switch data from an old database to a new one. I need
to know exactly how to design it as a relational database right from the
beginning. Thanks for everyone that would respond.