In Access versions prior to 2007 this would have been fairly simple to set up.
2007 and later versions the progammer has to arrange who can view what by setting up queries for specific people and possibly the use of some VBA code.
The essential part it to set up the management table giving the managers the "rights" that you want them to have.
You then need an employee table with references to their manager.
You will probably need a Cases tabel where the caseID and case description is entered and ideally a list of the possible errors with a table of error stuses as well.
You may need a departments table if required.
Data should only be entered once wherever possible and then referred to from then on.

I do not know of any tutorials, but I can guide you throught the process.