Questionnaire answered multiple times by the same person

[ak49]

I work for a company that uses semi trucks to deliver products to customers. We do safety audits on our drivers, we go find them in the field and observe the driver to see if our safe working methods are being used. A spreadsheet is printed out and manually filled in, but I would like to input the data into a database.



I have started out with a drivers table
employee id (primary key)
First name
Last
Middle

Currently there are 40 different questions to answer about safe work methods. I am hung up where to start. Every driver will be audited several times per year. So it is like a questionnaire that is filled out multiple times by the same person.

The ultimate goal is to have a database that I can find percentages from the different questions. Both by driver and our branch as a whole.

Your help is very appreciated.

[June7]

You need to gain a better understanding of what a relational database is and how the tables should be set up to relate records. Review this for a start http://forums.aspfree.com/microsoft-...es-208217.html

Consider besides the table of drivers additional tables:

Questions
QuestionID (primary key)
QuestionStatement

Audit
AuditID (primary key)
AuditDate
DriverID (foreign key)
AuditorID (foreign key)

Observations
AuditID (foreign key)
QuestionID (foreign key)
Answer

The drivers table could be expanded to be an Employees table so that the examiners would be included as well or if driver will never be an auditor and vice versa could have two tables.