db design!

[NeilBelgium]

I need to design an access database to print reports based on data (numerical) being entered.

The first step is setting up the db.
I have 40 people being rated by several of their colleagues (some bosses, some peers etc.) and a total
of 50 questions.
How on earth do I set up the tables?

The output is as follows: for every person being rated, the db must combine the totals of questions
1-5, 6-10 10-15 etc. to produce ten scores. But I also need the scores from peers, scores from bosses,
and total scores.
Do i need an immensely large amount of fields, or is there a way the db can count as it goes along?

With the reports, what's the best way to programme it to produce not only the results, but a pre-written
text dependant on the scores (five texts times ten scores) which are automatically generated.

I think that's generally it. How to set up the architecture, and some incredibly cools ideas about
producing reports.

OK, it can all be done manually, but it would take weeks!!

many thanks, neil

 

[hithere]

how often does this rating take place? (meaning, is it worth the effort?)

from the description, sounds pretty much like a straight-forward form driven db.
you could use a case statement to build a sql statement so that you can weight the returns if you want (so that a peers vote would count less than a boss vote). or so that the case would only sum boss's votes or only peer votes or all votes etc. Let's see, table could be 50 x 40 (q's & rates)...does the employee information live in an existing table? If so, you could do a table join with that one...maybe save some work that way. Are the questions already in a database? Again, maybe a chance to save some work there too.

I'm not familiar with it but...you might be able to remote script some of that as well so that it totals as it goes on the client side then sends the totals up to the server on form submission.

Just some initial thoughts.
hth
mark