Need help with training evaluation

[scubadiver]

I am messing around with a training database but I want specific help with
setting up the training feedback so I won't show all the tables. The way I
have it set up at the moment is

tble_employee
EmployeeID (PK)
Employee

tble_attend
EmployeeID (FK)
BookingID (FK)
Attendance (checkbox)

tble_booking
BookingID (PK: autonumber)
RoomID (FK)
CourseID (FK)
Duration
TrainingDate (FK)
TrainingTime
SupervisorID (FK)

tble_survey
BookingID (FK)
SurveyID (PK: autonumber)

tble_feedback
SurveyID (FK)
QID (FK)
ResponseID (PK: autonumber)

tble_question
QID (PK)
Question


I have been a bit intimidated about setting a database for survey entry. I
have had a go before so I vaguely know what is going on but I am not sure
whether the above is correct.

Cheers

 

[Steve]

Two observations ---
1. In tble_feedback, you have no provision to record the answer to the
question
2. In tble_question, you have no provision to relate the questions to a
specific survey.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[scubadiver]

thank you.

I have read this on numerous occasions!