Tags: access, brief, database, design, designed, entry, hii, microsoft, mysql, oracle, questionnaire, sql, storage
questionnaire database design
I have designed a small questionnaire and i want to use Ms Access for data entry and storage.
Here is the brief description.
2.date of birth
B.Sports Information about individual
1.do you play any spot --yes/no
2.what spot do you play --1.football 2.tennis 3.other
3.is your father still alive--yes /no
4.what spot does he play--1.football 2.tennis 3.other
5.at what age did you start school
6.what is your political affiliation 1.liberal 2.centre . other
C.For official use only
1.Date of interview---
2.How enthusiastic was the respondent--1.very 2.Average 3. Below average
How can i go about designing a relational database for the above questionnaire.
I need advice on the relational schema
Leave a comment...
- 4 Comments
- probably best to ask this in the Access forum.. so Ill move it there#1; Tue, 11 Dec 2007 21:07:00 GMT
- Have a look at Rudy's (R937) (http://www.r937.com/relational.html) site#2; Tue, 11 Dec 2007 21:08:00 GMT
- Here's a tutorial on designing an Access survey database:
http://www.functionx.com/access/applications/survey.htm#3; Tue, 11 Dec 2007 21:09:00 GMT
- The one thing I can tell you about a survey database (and I've designed quite a few) is try to avoid hardcoding the question into the fieldname! Questions will undoubtly change. I had a lookup table (1 field) which held the questions and a data table which populated a field with the question sentence and another field for the answer.#4; Tue, 11 Dec 2007 21:10:00 GMT