HR Evaluation Database...Printing

[gbonnaville]

I have created a database application for HR where managers will evaluate employees based on specific competencies. Each competency has 5 to 6 areas of peformance to be rated. The ratings are based on a scale of 1 to 5 with 5 being outstanding. The main menu and forms have been created, now my next step is to create the printable evaluation.

I.E. Under the Communication Competency, verbal skills is rated a 4, written skills is rated a 3...etc. So on the printed evaluation, instead of printing the ratings for each area, I need "Employee display sufficient verbal communication skills. Employee needs to improve their written communication skills."

My issues are....what is the best method of developing the printable evaluation? Exporting to Word? Using the Access report? How to create if....then code so that if the verbal field is a 1...it'll print "abc", if 2..it'll print "def", if 3....it"ll print "ghi"...etc.

Any suggestions or direction would be GREATLY appreciated!!

 

[DCrake]

Gor every question you would create a function that translates the number of the answer into a meaningful string

Sample

Public Function ReadingSkills(Answer as integer) As String


Select Case Answer
    Case 1:ReadingSkills = "Illiteriate"
    Case 2:ReadingSkills = "Stupid but saveable"
    Case 3:ReadingSkills = "Average"
    Case 4:ReadingSkills = "Excellent"
End Select

End Function

Then in your query you would use the function to retreive the approriate phrase

Reading:ReadingSkills([ReadingAbility])

 

[Lightwave]

Yes and then use the report designer in Access to print out as appropriate..
I wouldn't export to word I find the Access report writer very good.

The sentences are going to have to be pretty dry such that substitution of the equivalent strings still make sense... Simply write general statements and have the variable substituted in.

So you'll probably be stuck with simple direct statements.

This candidate is "illiterate"
This candidate is "socially disabled"
This candidate "suffers from personal hygiene issues"