Hi

I'm new to MS Access and would like to know if this is possible. I'd like a database with 4 hierarchy of management so that manager 1 would be at the top with multiple manager 2 and each manager 2 would have multiple manager 3 and manager 3 would have multiple manager 4 and each manager 4 would have multiple non-management colleagues under them.

Each manager would be able to view the data and statistics of the non-management colleagues under them (manager 1 would be able to view all non-management colleagues).


In the feedback tracker colleagues would enter another colleagues ID, case ID, Date the error was made status (Minor, Moderate or Major error) and description of the error, this will then add this feedback to the list that only the colleagues and managers in his hierarchy can view, there will be a sent list where colleagues can view the feedback they sent to other colleagues, the managers in their hierarchy would be able to view that as well.

there will be a page where the managers can view statistics of the number of errors, if their major or minor and higher management would be able to compare the statistics of their area, you would be able to compare the statistics on monthly basis to see if the team has improved from previous month or not.

if this is possible could you advise me where I would start to create something like this and are there any tutorials that can help me.

Thank you