If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
database surveys?
At first I wondered how to design a database to take in the information we
obtain from a town survey. Now I am thinking it would be best to start with the set up of the survey. If anyone has done large surveys where they will need to manually enter survey results into Access, please let me know the best way to set up the survey so results may be easily transferred to the database. Thanks, |
#2
|
|||
|
|||
I would produce a survey questionaire that has the statements/questions in the left column and the answers in the left as checkboxes like standardized computer scored test do. You can then assign a number (for data entry) value to each answer e.g. None=0, a Few=1, Some=2, Many=3, All=4.
In your db your table would have a record number and Question #1 as an Integer between 0 and 4, Question #2 as an Integer between 0 and 4, etc.\ The db form would then have all the question numbers and either a box to enter a number corresponding to the survey selection or an Option Group with 5 check boxes that would select 0-4. You can then do your math on the table anyway you want. Hope this helps, Bob Quote:
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report based on rst in other database | swedbera | Setting Up & Running Reports | 5 | October 6th, 2005 11:41 AM |
Access can't open database | Scott B | General Discussion | 1 | June 28th, 2005 04:16 PM |
Converting 97 database to 2003 database and implications | John | Database Design | 1 | November 22nd, 2004 05:23 AM |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |