Quality Questionaire Design - Reporting

[jmjbear1011]

Here is the issue (and thanks for the help):

I have a Quality Database that I am taking over. Be gentle, the design isn't good ...

(Keep in mind this is being redesigned)

There are 4 different quality questionnaires. Each has a dedicated table that logs pertinent info, and a reference table for the Employee. Questionaires range from 10 questions to 60 (max). So on each table it has all the pertinent info and one field per question(option groups are being used for responses of Y/N/NA). So currently there is one record per distinct id. With that there is a report that is printed daily, for imaging to image exact copies of the questionaire. So basically it is a mirror of the actual questionnaire form.. so it prints a different completed questionnaire per page of the report that is printed.

I was taking a look @ normalizing the database.

First question - if I normalize the databases, where all responses are logged by question id and response in its own table, how do I get those back into a single record for reporting purposes? Or is there a way to do it in one of the events to do it dynamically (maybe using a Select Case statement)? Or should I just create a query that uses expressions that are actually searching (i.e. select field1 from table1 where id = 1) or have it create a string of responses..

Second Question - Normalizing, in situations like this, where there are specific reporting needs is it still a good idea to go all the way to third form or is there any variance in that?

Third Question - Am I just going about this the wrong way? or am I on the right track?

 

[Beetle]

You might have a look at Duane Hookom's At Your Survey sample application. It should give you some insight on how a model like this is handled.