Tracking Employee Locations/Times

[Guest]

Hi! I work for a Special Education agency. We have many therapists that see
multiple children at multiple locations. They each submit a schedule of what
days in the week they see each their children. What's the best way to design
my DB so that I can make a report that will show me where they wil be and
when. For example, if I am going to supervise at a school, I want to be able
to print a report of which therapists will be there that day of the week. Or,
I might need a list of where all of my therapists are at a certain time of
day. (I have some knowledge of Access, as I have set up my human resources
and child info tracking on it, but I am not an expert, so please bear that in
mind)

Thanks in advance!!!

 

[Guest]

You don't want to repeat static entries in multiple locations. Based on your
description but without being real precise - in general you need these
separate Tables:

Therapists Info Table
Students Info Table
Location Info Table
Meetings

I assume the first 3 table data is relatively static. They of course change
and get updated occasionally. It is the Meetings Table that will be the
cross reference of the other 3 tables. It would contain the cross reference
fields plus the unique meeting info...ie:

Therapist ID (from Therapist table)
Student ID (from Student table)
Location ID (from Location table)
Meeting Date
Meeting Info1
Meeting Info2
etc...

You will then be able to query & report all the info.