Tabledesign - Howto

[Guest]

Hi
Being new to Databases/Access I hope someone can help me with this:

I'm trying to build a database (Access 2003) to handle participants
evaluations of various courses. After completing the course participants are
requested to fill out a total of 20 predefined questions. I want to connect
these answers with a specific person (participant) on a specific course.
My problem is how to design my tables. I've tried with the following tables:
tblParticipants (PersonID, FName, LName, CourseID, QuestionsID, Answer(s))
tblCourses(CourseID, CourseName)
tblAnswers(PersonID, AnswerID, QuestionID, Answer)
tblQuestions(QuestionID, well, here's a problem: How should I design this
table?)
I just can't see how to get these questions into the database without having
to specify them in every participants record.

Hope it all makes sense and that someone can understand my inexperienced
attempt to describe databases.

 

[Guest]

I think you're close. You should remove the QuestionId and Answer columns
from the Participants table. These will be stored in the answers table.
You'll relate the Participants table to the ansers table though the PersonId
field in the answers table.

You also need a Question column in your Questions table that holds the
actual question text.

Hope this helps,
Barry

 

[Jeff Boyce]

You may find some ideas/assistance by looking at the application Duane H.
wrote:

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

You may find some ideas/assistance by looking at the application Duane H.
wrote:

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

Regards

Jeff Boyce
Microsoft Office/Access MVP






Thanks a lot for pointing me to rogersaccesslibrary.com... There's plenty of usefull stuff to inspire and enhance my knowledge about databases.

Regards Mopton

 

[Guest]

Thanks Barry

Did what you suggested but still have some trouble. I want every participant
to answer all 20 questions but I only get one question per participant.

Anyway, as I wrote, I'm completely new to access so I guess I will have to
study keys, foreign keys, queries etc. and etc.

Once again Thank you very much

Mopton

 

[Guest]

In the query, look at the relationship between the two tables. It should be
one-to-many, meaning one side has an arrow. I'd guess that neither side has
an arrow. yet. Double-click the line and try both options. You'll get the
idea of how one-to-many relationships work.

Barry