Need advice on how to format reports

[KateCee]

I have structured tables to track and calculate StoreDetective schedules, but
now I have to make sure I can easily pull the following reports:

StoreDetective schedules by FieldManager (5 Field Managers)
StoreDetective schedules by Store (100 stores)
StoreDetective schedules by District Manager (10 District Managers)
StoreDetective schedules by StoreDetective (100 detectives)

Any suggestions on how to make a format to pull these reports weekly? It
would be virtually impossible and very unadvisable for me to make individual
queries for each, but I have to make sure this is all established so database
operators may access this data through a few clicks. Those people who will
be working with this database have little or no knowledge of Access.

FYI: I have 5 tables

tblStoreDetectives (lists name and contact info)
tblScheduling (contains a foreign key to link to tblStoreDetectives and
lists start and end time of shifts for each day of the week and store number)
tblFieldManagers (a list of 5 names)
tblDistrictManagers (a list of 10 district managers)
tblStores (list of about 100 store #s, location, city)

So far, I have 1 query which is a combination of fields from
tblStoreDetectives and tblScheduling in order to schedule and calculate
hours.

Thanks, any other input would be greatly appreciated!

Kate