I am looking to build a database to track employee performance. We currently use an Excel Spreadsheet. My boss has chosen to break the reporting periods up into Blocks (A-J), made up of 4 weeks. So I have 10 spreadsheets named Block A, Block B, etc, made up of a Sheet per employee to track that individuals performance. I also have a sheet called Dashboard on each spreadsheet, that reflects the overall score of each employee for that Block and a Scoring Sheet, that prints a report of sorts for the employee that shows them their overall scores for that Block. The rows of the spreadsheet store 15 yes/no questions that equal a value of 1 if the answer is yes. The columns have the are broken up into week 1, week 2 and so on with the individual dates underneath. The cells store the value 1 if the employee has completed the performance task. At the end of the columns, I have a calculated field that shows the scores per performance question, per block.
I would like to turn this into a database, that has a form that I can enter the individual employees scores, a form where a can select an employee from the list and view a particular range of scores (by week and block), email a report to the employee with an overview of their score per week and block, and email my boss, weekly and monthly reports showing how each employee is tracking. I would like assistance on the best way I could create this database.