Employee Evaluations

[Whois Clinton]

I am a newbie to Access. I need simple tracking for annual employee
evaluations. I have 1 table with Employee Info (Name, DOB, Hire date, etc)
and a 2nd with the evaluation criteria (Attendance, follows protocol, etc. as
columns and numbered entries as scores for each.

I would like the Employee info to fill itself out once the employee has been
identified. For instance I choose from Last Name "Smith", then First Name
"John", then date of hire, position, location etc. all fill themselves in,
then I enter the eval scores.

I have done some studying on here but cannot find the exact match. I am
also at very beginning stage creating this so I can start from scratch easily.

Thanks in advance,
Clinton

 

[golfinray]

That is generally not the way you want to go. What if someday you have 2 John
Smiths? A better way is to use a unique employee number. You can have access
do that for you in your table of employees by adding a field and setting (in
design view) the datatype to autonumber. Or if you want to enter your own,
you could enter 0001, ooo2, or whatever configuration you like. Set that ID
as the primary key (again in your tabgle in design view) and then you should
be good to build your entry form. Use the form wizard to build it for you.
Then come back to this board and ask further how to set up where you can find
the emplyee information by ID number and month or week.

 

[Duane Hookom]

Before you get to far with your current table structure, you might want to
check out the normalized solution at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=15&SID=d928z3fb89c4z651b53d6ef2z7b632c3.

 

[De Jager]

I am a newbie to Access. I need simple tracking for annual employee
evaluations. I have 1 table with Employee Info (Name, DOB, Hire date,
etc)
and a 2nd with the evaluation criteria (Attendance, follows protocol, etc.
as
columns and numbered entries as scores for each.

I would like the Employee info to fill itself out once the employee has
been
identified. For instance I choose from Last Name "Smith", then First Name
"John", then date of hire, position, location etc. all fill themselves in,
then I enter the eval scores.

I have done some studying on here but cannot find the exact match. I am
also at very beginning stage creating this so I can start from scratch
easily.

Thanks in advance,
Clinton