"=?Utf-8?B?TWltaQ==?=" wrote in
:
Now I need to figure out where to
go from here w/out completely starting over.
I am not sure that this is not the best place to start... :-)
Taking things from the top, I see that you have entities called
Years
Days
IDs
Questions
Answers
but I am not clear exactly how they all interact. Some things are
(probably) easy -- each Day belongs to exactly one Year; there is at most
one Answer for a given Question on a given Day by a particular ID; and so
on. My guess is that you are looking at tables something like this
Days(*YearNum, *DayNum, etc) to track days when surveys were taken
Questions(*QuestNum, TextOfQuestion, CorrectAnswer, AnswerType) which is
fairly obvious, except that if you make CorrectAnswer a text field,
then you can use it to store a numeric answer and set AnswerType to
a code that specifies "number", if you see what I mean. I would also
have urged you to keep all questions to a consistent answer type, but
you can't have everything!
Subjects(*SubjectID, FName, LName, Agegroup, Gender, etc)
Responses(*YearNum, *DayNum, *QuestNum, *SubjectID, GivenAnswer) This is
the table that holds one record for each question from each subject on
each day. You can group by year, or by day; do totals for each Subject,
and by suitable joins you can analyse by gender or agegroup etc etc.
One short cut would be to look at the ready-made At Your Survey database
from our very own Duane Hookom: check out
http://www.rogersaccesslibrary.com/OtherLibraries.asp
Even if it does not fit your needs exactly, you can see how to build a
similar application that does.
Hope that helps
Tim F
|