Employee evals

[Guest]

I'm trying to create an Access 2007 database for Employee evaluations based
on job descriptions?

Job descriptions have many paragraphs and staff will have a variety of these
paragraphs in their job description. The paragraphs are grouped by category
(ie. Quality of work)

Any suggestions? Thanks,

 

[Allan Murphy]

Nancy
Just a suggestion Have a column called Category and another called
job_description. then create records where Category would be Quality of work
and each Job_description would be paragraph 1 for the first record paragraph
2 for the second record

Category Job Description
Quality of Work Paragraph 1
Quality of Work Paragraph 2
Quality of Work Paragraph 3
etc.


Allan

 

[Guest]

Thank you for responding. That's kind of the track I was on, but I have so
many levels. sometimes one of the paragraphs can be used for several
different job descriptions. Several people can have the same job with some
paragraph the same and some different.

I have the following tables:
Employee, Job, Category, Group, job details (paragraphs). There are also
scores at the Group level. Plus the end users are social workers not
computer people.

Up till now I have each person's eval in Excel but my users have difficulty
with row spacing and printing. I don't like the fact that they have to type
in the same paragraph for staff who change jobs or copy an existing eval.

Thanks for your help. Nancy