Hello,
I am creating a Master Employee Database for my job. It will contain 400+ employees (regularly changing) and will automatically calculate necessary items such as sick time accruals, evaluation dates, etc. I've created that part along with the Data Entry forms to search and update the database. Now, I'm looking to really expand upon the idea.

On a monthly basis, Quality Assurance (QA) needs to be performed on each employee. There are 4 different categories (911, DLE Radio, FR Radio, Teletype) for the types of QA's, and each of the 4 types will contain anywhere from 12-17 different criteria to be judged ("Calls Answered Correctly", "Extended Reasonable Assistance", "Proper Units Assigned", and a myriad of others). The only acceptable answers are: Satisfactory, Non-Satisfactory, and NA. Currently, the Quality Assurances are written on a simple PDF form and not entered into a database, which is what I am looking to do. The Supervisor selects a different category each month. So Employee A's QA for the first month is 911. That particular form contains 17 questions. The second month, a Teletype QA is performed, and that one only contains 12 questions. There is no specific order for which QA is done when, but that can also change in the future.

What I am trying to do is automate the process by having the Supervisor do the QA on an Excel form and have that data dump into a database. From that database, I would be able to track, across all employees, areas that might require additional training or trending problems. Also, I'd like to be able to determine, on an employee by employee basis, the areas of greatest concern.....of an employee consistentlt has issues with the same category, I'd like to be able to find it quickly and easily. I might eventually assign numeric values to each of the questions in order to develop an Employee Efficiency Rating.

I would attach my database, but the file is too large, and the parts that I already have written do not really apply to this question.

So, does anyone have any suggestions or ideas how I can do this? I am trying to become the uality assurance Supervisor, and some sort of Tracker would really get me on the right path. Thanks!!