Tables - are more needed

[Nadine]

I have a table with the employees names and their workgroups
I have a table for entering questionnaire results

Later will be building statistical reports on the questionnaire results.
by employee and by workgroup, and by all.

Just wandering if I would need a seperate table that listed the names of the
workgroups, and relate it to the other tables, to be able to build the
required reports.

I'm thinking just by relating the employee table and the questionnaire
tables together should be sufficient, to enable me to build the necessary
reports. But thought I should check.

thanks
Nadine

 

[Douglas J. Steele]

To see what's required for a well-designed survey, take a look at Duane
Hookom's "At Your Survey"
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

Yes, relating the employee table to the answers should be adequate.

 

[Nadine]

Thanks for the input and the link, I'll check it out see if it meets my
needs. Thanks

 

[Tony Toews [MVP]]

I have a table with the employees names and their workgroups
I have a table for entering questionnaire results

Later will be building statistical reports on the questionnaire results.
by employee and by workgroup, and by all.

Just wandering if I would need a seperate table that listed the names of the
workgroups, and relate it to the other tables, to be able to build the
required reports.

I'm thinking just by relating the employee table and the questionnaire
tables together should be sufficient, to enable me to build the necessary
reports. But thought I should check.

What happens when the employee changes work groups from one survey to
the next? You may wish to record the employee workgroup when the
results for that survey are entered in the survey "header" table.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/