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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |