Hi all.
I have been tasked with creating a system that will allow heads of department (HoDs) and SLT to add lesson observation details for all staff. They(SLT) then want individual staff to be able to access ONLY their data, HoDs to access data for their department and SLT to see all data.
I have thought about sharing an excel file, but this would just be too messy with all the staff (100 staff in total). Would a Database be better with leveled users ( but then how do I stop others from seeing data that was not related to them?)The school has offfice 365 with associated apps, I can't see one that is better for this type of system.
Does anyone have any suggestions?
TIA,
JonesC
