|
| 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
February 24th, 2005, 11:45 AM
|
|||
|
|||
table design
I created a survey table in database...But my question is how can you create
tables and name columns for a survey, if you were me??Are these enough column names??Or should it be more? SURVEY_HEADER --------------------------- CENTER_ID CENTER_RESPONSIBLE CENTER_RESPONSIBLE_TITLE CENTER_RES_RESPONSIBILITY UNIQUE_ID QUESTIONS ----------------- UNIQUE_ID QUESTION_ID QUESTION ANSWERS ----------------- UNIQUE_ID QUESTION_ID ANSWER INVENTORY ---------------- UNIQUE_ID INVENTORY_ID INVENTORY ANSWER_ID SURVEY_DETAIL ---------------- UNIQUE_ID CENTER_ID ANSWER_ID ANSWER 
|
|
#2
February 24th, 2005, 12:24 PM
|
|||
|
|||
|
If you'd like a point of comparison,
Duane Hookom has a sample survey database at http://rogersaccesslibrary.com/Other...p#Hookom,Duane -- Good luck Jeff Boyce Access MVP "aylin_sk" wrote in message ... I created a survey table in database...But my question is how can you create tables and name columns for a survey, if you were me??Are these enough column names??Or should it be more? SURVEY_HEADER --------------------------- CENTER_ID CENTER_RESPONSIBLE CENTER_RESPONSIBLE_TITLE CENTER_RES_RESPONSIBILITY UNIQUE_ID QUESTIONS ----------------- UNIQUE_ID QUESTION_ID QUESTION ANSWERS ----------------- UNIQUE_ID QUESTION_ID ANSWER INVENTORY ---------------- UNIQUE_ID INVENTORY_ID INVENTORY ANSWER_ID SURVEY_DETAIL ---------------- UNIQUE_ID CENTER_ID ANSWER_ID ANSWER
|
|
#3
February 24th, 2005, 12:43 PM
|
|||
|
|||
|
Thank you so much Jeff, but i havent got Access in my pc...so i cant see the
tables and columns...im at work now...do u have an opinion about my survey table? "Jeff Boyce" wrote: If you'd like a point of comparison, Duane Hookom has a sample survey database at http://rogersaccesslibrary.com/Other...p#Hookom,Duane -- Good luck Jeff Boyce Access MVP "aylin_sk" wrote in message ... I created a survey table in database...But my question is how can you create tables and name columns for a survey, if you were me??Are these enough column names??Or should it be more? SURVEY_HEADER --------------------------- CENTER_ID CENTER_RESPONSIBLE CENTER_RESPONSIBLE_TITLE CENTER_RES_RESPONSIBILITY UNIQUE_ID QUESTIONS ----------------- UNIQUE_ID QUESTION_ID QUESTION ANSWERS ----------------- UNIQUE_ID QUESTION_ID ANSWER INVENTORY ---------------- UNIQUE_ID INVENTORY_ID INVENTORY ANSWER_ID SURVEY_DETAIL ---------------- UNIQUE_ID CENTER_ID ANSWER_ID ANSWER
|
|
#4
February 24th, 2005, 04:43 PM
|
|||
|
|||
|
I think you seem to be on the proper track with your table designs. It looks
fairly normalized which is great. The link supplied by Jeff has similar structures with a full implementation including forms for creating surveys, entering results, and creating reports. -- Duane Hookom MS Access MVP -- "aylin_sk" wrote in message ... Thank you so much Jeff, but i havent got Access in my pc...so i cant see the tables and columns...im at work now...do u have an opinion about my survey table? "Jeff Boyce" wrote: If you'd like a point of comparison, Duane Hookom has a sample survey database at http://rogersaccesslibrary.com/Other...p#Hookom,Duane -- Good luck Jeff Boyce Access MVP "aylin_sk" wrote in message ... I created a survey table in database...But my question is how can you create tables and name columns for a survey, if you were me??Are these enough column names??Or should it be more? SURVEY_HEADER --------------------------- CENTER_ID CENTER_RESPONSIBLE CENTER_RESPONSIBLE_TITLE CENTER_RES_RESPONSIBILITY UNIQUE_ID QUESTIONS ----------------- UNIQUE_ID QUESTION_ID QUESTION ANSWERS ----------------- UNIQUE_ID QUESTION_ID ANSWER INVENTORY ---------------- UNIQUE_ID INVENTORY_ID INVENTORY ANSWER_ID SURVEY_DETAIL ---------------- UNIQUE_ID CENTER_ID ANSWER_ID ANSWER
|
|
#5
February 25th, 2005, 06:17 AM
|
|||
|
|||
|
Thank you so much Duane about your opinion...
"Duane Hookom" wrote: I think you seem to be on the proper track with your table designs. It looks fairly normalized which is great. The link supplied by Jeff has similar structures with a full implementation including forms for creating surveys, entering results, and creating reports. -- Duane Hookom MS Access MVP -- "aylin_sk" wrote in message ... Thank you so much Jeff, but i havent got Access in my pc...so i cant see the tables and columns...im at work now...do u have an opinion about my survey table? "Jeff Boyce" wrote: If you'd like a point of comparison, Duane Hookom has a sample survey database at http://rogersaccesslibrary.com/Other...p#Hookom,Duane -- Good luck Jeff Boyce Access MVP "aylin_sk" wrote in message ... I created a survey table in database...But my question is how can you create tables and name columns for a survey, if you were me??Are these enough column names??Or should it be more? SURVEY_HEADER --------------------------- CENTER_ID CENTER_RESPONSIBLE CENTER_RESPONSIBLE_TITLE CENTER_RES_RESPONSIBILITY UNIQUE_ID QUESTIONS ----------------- UNIQUE_ID QUESTION_ID QUESTION ANSWERS ----------------- UNIQUE_ID QUESTION_ID ANSWER INVENTORY ---------------- UNIQUE_ID INVENTORY_ID INVENTORY ANSWER_ID SURVEY_DETAIL ---------------- UNIQUE_ID CENTER_ID ANSWER_ID ANSWER
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
| unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
| Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
| Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |
| COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Linear Mode
