The Area being Modelled is :-
Tracking Hospital Staff

My question/request is regarding hospital management�
I�m looking to create a database that would track staffing.

I�ve looked at the models for Hospital Staff and Nurses Roster (as well as a payroll model
which I can�t locate again�) and I�d like to take pieces from each of them�

The goal is to track/display staff that are on for each shift, for each of several ward locations
(starting with only 1 ward), display alerts if staffing is below minimum (total # and licensed staff), input/confirm daily staffing
with any leave/overtime for that day, ensure that each staff member is working the correct hours (biweekly)� and I can think of
many of things to group in eventually, but I have to start somewhere!

I had started with a table for staff info that included: LName, FName, Location, Shift, Hours, and Position
but looking at the Nurses Roster model, I can see that pulling staff info into a daily roster table (or query? Form?) and having
a separate table for shifts seems to make a lot more sense�

The current systems being used consist of a shared excel workbook that has data entered manually by each ward, along with each
ward manager creating a schedule in excel biweekly (and each manager has their own slightly different template).

Data is entered several times over, with some things done by hand.

Scrambling around is a daily occurrence and, ideally, I�d like to stop that�

Oh, and I work at a federal hospital in the US, if that�s important.
That would probably explain the inefficiency!

I realize that this is a very basic scheme and it may very well be beyond me.
I don�t want this to seem like a request to design a database (sorry if it seems like that!)
but I�d like to know if I�m on the right track at all� whatever information you�d be able to
send my way would be greatly appreciated as I continue to take courses and tinker on my own.

Thank you,

Jason