Tracking Employee Locations/Times

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!
 
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.
 
Back
Top