Questionnaire HELP!
Jun 21, 2006
Hi,
I have the task of creating a new questionaire and associated reporting. Normally I would have done this in Excel, but due to the size I feel it is neccessary to create this in Access.
My question is should I revise my table of completed forms? I initially planned to create a form to populate the completed forms table. Job done?
However I am sure I have read somewhere this is not the best in terms of reporting and I should have a table of answers for each question? Is this correct I have approx 50 questions?
I have the following tables:
1) Staff Details
2) Table Of Questions
3) Table Of Answers (Questions are multiple choice)
4) Table of completed forms
View Replies
Jan 4, 2005
Hi
Wondering if anyone can suggest how I might be able to deal with a questionnaire. I thought about doing a straightforward database with all the questions listed as fields in the one table but I think there are too many questions/fields (about 200, definitely not 254 but still raises an error message of "Too Many Fields Defined). The questionnaire will be an on-going process, with users re-submitting their answers every quarter. I do want to be able to analyze the data and create reports, etc. so am hesitant about using Excel. For instance, I did a basic report involving Excel and then adding many columns to calculate various averages - the report was made in Word and I mail-merged in the data from the spreadsheet. Long-winded for just one report and I'm hoping to avoid this.
Any suggestions are welcome.
Thanks and regards.
View 2 Replies
View Related
May 22, 2007
I'm building a questionnaire/survey database for my work. Everything seems pretty straightforward, but I'm a little unsure about how to store the survey configurations.
I'm assuming that the survey will change sometime between now and the end of time so I'm tracking survey configurations (which questions and in what order). Right now my "Configuration" table has two fields: ConfigID (Autonumber), Questions (Memo). The 'Questions' field is a space seperated list of question IDs. The other way I could've done it is to use three fields: ConfigID (Long), OrderNum (Int), QuestionID (Long).
I figure the first way is more memory efficient in the long run and it will take much less time to add a new configuration.
The way I'm doing things now works for me, but I'd like to know if anyone thinks I'm setting myself up for trouble down the road or if my way is actually less memory efficient (I'm not as concerned with processing time).
View 2 Replies
View Related
Jun 26, 2007
Hi
I have designed a small questionnaire and i want to use Ms Access for data entry and storage.
Here is the brief description.
------------------
A.Heading
------------------
1.Person id
2.date of birth
3.age
4.sex
5.school
-----------------------
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
thanks
View 2 Replies
View Related
Mar 3, 2006
To start: Running Office 20003. I have created a survey with Frontpages wizard. Basically It has a topic and the end user rates that topic on a scale of one to five like so:
1. Work Environment
a. I enjoy my work place. 12345
b. I think my office has a good reputation. 12345
1-5 are radial buttons. It takes the users input and stores it in an access database as im sure you all are aware. Looks kinda like this:
1a 1b 2a etc.
3 5 1
What i would like to do is this: When the users are done submitting i would like to go back and take results. I.e. we had this many users select option 3 for question 1a and we had _ number of users select option 2 for 1a, etc.
The thing is i was wondering if there was a way to create a query for it. I know i could just put =1 or =2 but that would require running 5 queries on each question.... not fun. Anyway, any help would be appreciated.
Thanks,
Viko
View 1 Replies
View Related
