Appraisal Database Help

[Chimp8471]

i need to construct a database to store info for the appraisal system which is going to start at our company in the near future...

but am not too sure how to go about this looking at the form i have attached.

i think that i should have a table full of the employee's details and also a table of deparments, and also a table of Job Titles...

but after that i am a little unsure....

you will see that there are a number of sections to the appraisal, would it be best to have all these sections in one table or in seperate tables.

advice please

cheers

Andy

 

[wizcow]

Andy

If it were me, I would make a table for the appraisal too.
As each Appraisal is one record I would make just one table.
Make an Appraisal form.
Your Name and Appraiser ect. would be combo boxes tied to the employee details table.
Then I would make a series of radio buttons and check boxes for 'Application' ect.
You could then build a report to look exactly like your attachment.

HTH
Tom

 

[Chimp8471]

thanks for your reply,

i have started very briefly to put this together, but am a little lost at how i am going to display each section within the table....

for example in section 1

i have the following Question :

it is split into a number of sections

the Actual question

1) APPLICATIONConsider/discuss the energy and attentiongiven to work. Is it consistent or is the work carried out in fits and starts?

then

the Answer and Scoring

Outstanding. Keen & enthusiastic. Sustained effort. 5
Applies self steadily & attentively. 4
Works consistently but without enthusiasm. 3
Below standard. Not always diligent or attentive. 2
Unsatisfactory. Half hearted & indifferent. 1

and then the Comments Box, i am just a little unsure of teh best way to put this into my table.

my table named tbl_appraisal contains:

tbl_Appraisal
AppraisalID (PK)
AppraisalDate
AppraisalStartTime
AppraisalEndTime
EmployeeID - (to link to the relevant employee)

cheers

Andy

 

[wizcow]

Andy

Put another field in your table named Application.
Set it to numeric.
On your form you could have a text box tied to this field.
You give instructions, by way of a textbox, to your users to enter a number between 1 and 5.
Then add another field in your table named ApplicationMemo.
Set it to memo.

At the bottom of your form you can have a textbox named Total.
In the controls source put something like this...
=[Application]+[Ability]+[Attitude] etc.
This will add the textboxes for you.

If you wish to make your form a little flashier (and user friendly)
you could add option buttons. The Access help files have tons on Option buttons. And for your yes/no questions you could use check boxes.

Good luck
Tom