Need help with training evaluation

G

Guest

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
 
S

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)
 
S

StopThisAdvertising

Steve said:
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

--

Hey Steve !!
Well... We did know that you are NOT an Access resource at all !!
But .... A REAL resource you are with Excel .... Ha ha ha. !!
Asking questions about looping a spreadsheet, asking about Excel-events, not knowing how to add buttons and code ???
http://groups.google.nl/group/microsoft.public.excel.programming/msg/d7d79687dec86195?hl=nl
http://groups.google.nl/group/microsoft.public.excel.programming/msg/a4a8b9b40fe5c313?hl=nl
http://groups.google.nl/group/microsoft.public.excel.programming/msg/46a46c0dc6dc9c15?hl=nl

Curious about your Word skills... You DO know that you can bold text and such ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3950+ pageloads, 2500+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top