Help Designing Speaker Evaluation Database

[puttypapyrus]

I am having trouble designing the tables and establishing relationships
for a survey database for the purpose of evaluating speakers for a
variety of events. After every event, the attendants are asked to fill
out an anonymous survey assessing the overall effectiveness of the
seminar (on a scale of 1-10) in addition to giving a 1-10 rating for
each speaker and associated content at the event. I'd like to set it
up so that I can enter in survey data straight from the survey but I
don't know how to deal with the issue of the variable number of
speakers at every event. The questions are very straightforward:

Rating of Event
Additional Event Comments
Rating of Speaker 1
Rating of Content 1
Module 1 Comments
Rating of Speaker 2
Rating of Content 2
Module 2 Comments
etc...

How would I compensate for this? Also, after all the survey data is
entered, is there a way I can calculate the standard deviation of the
ratings for each speaker (as well as the overall event rating) and
present it in a report? Thanks.

[jahoobob via AccessMonster.com]

You need an events table and a speakers table. Each event would have an
EventID primary key and other information and each speaker would have an
EventID foreign key with their ratings information. You of course would
enter the data via a form for the event with a subform for speakers. when
you link the two forms by EventID, each speaker's record will have the
EventID in it.
This is if you want to keep the ovreall ratings. If you want to store the
raw data of each individual survey you will need to add a SpeakerID primary
key to the speaker's table and add a new table of ratings with the SpeakerID
as a foreign key. You will need to add a subform to the speaker's subform
and link on SpeakerID. Note: Don't store the summary ratings in teh
speaker's table if you store the raw data in a ratings table. You can always
get the summary info form the raw.
Hope this helps,
Bob

pu**********@gmail.com wrote:

>I am having trouble designing the tables and establishing relationships
for a survey database for the purpose of evaluating speakers for a
variety of events. After every event, the attendants are asked to fill
out an anonymous survey assessing the overall effectiveness of the
seminar (on a scale of 1-10) in addition to giving a 1-10 rating for
each speaker and associated content at the event. I'd like to set it
up so that I can enter in survey data straight from the survey but I
don't know how to deal with the issue of the variable number of
speakers at every event. The questions are very straightforward:

Rating of Event
Additional Event Comments
Rating of Speaker 1
Rating of Content 1
Module 1 Comments
Rating of Speaker 2
Rating of Content 2
Module 2 Comments
etc...

How would I compensate for this? Also, after all the survey data is
entered, is there a way I can calculate the standard deviation of the
ratings for each speaker (as well as the overall event rating) and
present it in a report? Thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1