My office has 6 branches (Br1,Br2…Br6)across India.
Under each branch there are 70 Managers(M1,M2…M70), each manager has one team(T1,T2…T70)
Under each manager there are 1 to N number of employees.(E1,E2…En)
I want to make one DB file(shared) in which these 70 Managers can update all details of each employee.These details may be put column wise ,for eg Column 1 contains Name,Column 2 contains Dob etc…Atleast there are 25 columns or details which I want them to update.
Each employee detail will be updated row wise , For eg Row 1 has Employee 1 detail of Manager 1,Team 1 under Br 1.Row 2 has Employee 2 details of Manager 1 ,Team 1,under Br 1. And so On.
Finally once each manager under each location will finish data updation, i can see that consolidated data .
I don’t know how to make this DB file in Excel and how to assign user name and password to each manager so that they can only update there part and no manager can see or update details other than his team but he is the Admin who can see or update all the details of that file.
Any help where from to start this project and how would be appreciated.