Employee Performance Tracking System

I'm seeking an HR management professional to help establish an effective employee performance tracking system. The ideal candidate will have experience in setting up systems for performance reviews and goal setting and tracking.

Key Responsibilities:
- Developing a framework for regular performance reviews
- Implementing a system for goal setting and tracking

Desired Skills and Experience:
- Prior experience in HR management, specifically in employee performance tracking
- Strong understanding of creating and managing performance review systems
- Excellent organisational and communication skills i have a detailed how to from chat gpt tep 1: Open Microsoft Access
Open Microsoft Access on your computer.
Click Blank Database and name it, e.g., PerformanceReviewSystem.accdb.
Step 2: Create Tables
Employees Table
Go to Create > Table Design.
Add the following fields:
EmployeeID (Short Text, Primary Key)
Name (Short Text)
Position (Short Text)
Department (Short Text)
MonthOfHire (Date/Time)
CurrentWage (Currency)
Save the table as Employees.
PerformanceCriteria Table
Go to Create > Table Design.
Add the following fields:
CriteriaID (AutoNumber, Primary Key)
CriteriaName (Short Text)
Description (Short Text)
Save the table as PerformanceCriteria.
Reviews Table
Go to Create > Table Design.
Add the following fields:
ReviewID (AutoNumber, Primary Key)
EmployeeID (Short Text, linked to Employees.EmployeeID)
CriteriaID (Number, linked to PerformanceCriteria.CriteriaID)
Score (Number, Range: 1-5)
EmployeeSelfFeedback (Long Text)
ManagerFeedback (Long Text)
SubmissionDate (Date/Time)
IsSubmitted (Yes/No)
ManagerID (Short Text)
Save the table as Reviews.
CompanyFeedback Table
Go to Create > Table Design.
Add the following fields:
FeedbackID (AutoNumber, Primary Key)
EmployeeID (Short Text, linked to Employees.EmployeeID)
FeedbackText (Long Text)
SubmissionDate (Date/Time)
Save the table as CompanyFeedback.
Step 3: Link the Tables
Go to Database Tools > Relationships.
Add all four tables (Employees, PerformanceCriteria, Reviews, CompanyFeedback) to the relationship window.
Link:
Employees.EmployeeID to Reviews.EmployeeID.
PerformanceCriteria.CriteriaID to Reviews.CriteriaID.
Employees.EmployeeID to CompanyFeedback.EmployeeID.
Enforce Referential Integrity.
Step 4: Create Forms
Employee Self-Feedback Form

Use Reviews as the base table.
Include fields: EmployeeID, CriteriaID, Score, EmployeeSelfFeedback.
Add instructions and lock the form after submission (use the IsSubmitted field).
Manager Review Form

Use Reviews as the base table.
Include fields: EmployeeID, CriteriaID, Score, ManagerFeedback, SubmissionDate.
Lock EmployeeSelfFeedback to prevent editing.
Step 5: Add Sample Data
Enter sample employees, criteria, and reviews to test the system.