Attendance Tracking in Access for Therapy Groups

Hello, I work in a hospital and I am attempting to create a new Access database for tracking patient attendance to therapy groups. However, I am not overly familiar with Microsoft Access and could benefit from some expertise.

My needs are as follows:

• Ability to generate a daily group-specific form (as in the type of therapy group) which can be printed and utilized by clinical staff to record physical attendance and reconcile with an electronic form entry into the database.
• Ability to track total group participation as an average of my entire patient census at any given time
• Ability to assign patients to assigned therapy groups (but not automatic tracking as attendance is always optional)
• Ability to run data analysis on our group offerings and attendance rates over time

My idea for the project:

Create two content types: Patients and Therapy Groups

Patient content type will include items such as:

• Admission/Discharge dates (will need to be able to process re-admissions for returning patients)
• Hospital Unit where the patient is being treated
• Relevant treatment/medical factors which we may want to compare against attendance rates

Therapy Group content will items such as:

• Date
• Lead clinician
• Type of group
• length of group
• attendance of each patient attending group on that day

Flow of utilization:

Before holding a group a clinician will generate a group-specific form with a list of patients who are assigned to that group.

The clinician will use this form and mark attendance to the group that day

The clinician or the clinician's manager will collect paper forms and update the electronic version of the form to designate yes/no regarding the attendance of individual patients on the form.

This form will feed data into my database which will track:

• Each group (by day) which patients attended
• Each Patient (by day) which groups did they attend?

Final goal: To be able to analyze a particular time period and compare total patient census (at those times, census changes on a daily basis) to treatment hours provided.

While I think I have a decent handle on the project but if anybody in the community has created a similar database and related forms I would love to see a template!