Help Desgining Database for Speaker Evaluations

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

 

[Jeff Boyce]

Have you looked into the AtYourSurvey application that Duane Hookom created?

http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

It may cover a lot of what you're trying to do.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/