Re: Rating Database Access 2003

I am not trying to link it to a spread***, I want to start a new system to
rate and compile rating data on employees. I want to be able to use the
individual audit records to produce hard copy feedback forms for individual
employees.

i.e. I will pull a random sampling of work, and rate it based on eight
criteria. Each criteria will have four catagories: excellent, proficient,
developing and unsatisfactory.

On the form, these catagories will be assigned a point value, and those
combined point values totaled and averaged to create a rating.

The form can then be printed out for the employee to review in
coaching/development sessions. Then the data can be queried.

Am I too ignorant at this point to design such a db?

"Jeff Boyce" wrote:

From your description, it sounds like you are asking if your Access table(s)
should look like a spread***. You can do that, but you won't get much
advantage of Access' relationally-oriented features and functions if you
feed it '*** data.

If you are not familiar with the topics of normalization and relational
database design, there's a steep learning curve in your future before you'll
be able to make (full-er) use of Access.

If you ONLY need to use Access to report on data, could you simply link to
your Excel spread*** itself and generate the reports?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"debinnyc" <debinnyc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51B8E12D-3541-4204-BFB2-1583F9EC43F6@xxxxxxxxxxxxxxxx
I am trying to create a database to record performance measures for
individual people in an office. I will need to record multiple samples per
month, based on production. My first thought was to create a single table
with all the fields, but I see in other discussion topics there is a way
to
create multiple tables and link them together.
Here is an example of what I want:

Empl Id, name, dept, supv name, audit number
Quality measure 1 (check box) excellent , (check box) good, etc...
point
value
.
.

average point value
notes

I am assigning a unique id to each record through an auto number field
such
as audit number.
So, if I have thirty employees and I perform 4 audits per month per
employee, I can record each audit, and analyze each employee's performance
over time based on scoring.
Does that make sense? I hope so.

Sorry, I have used access for a while from a reporting standpoint but have
little experience in design. Any help would be greatly appreciated.



.