Hi all,

I'm relatively new to Access and would like a few pointers...

I have been asked by work to create a schedule database. We would like to be able to put in dates and see who's working on that day, pull up an individual and see his/hers rota for a week. Also see if they have meetings, annual leave, sickness etc.... We want it to be a very primitive WFM tool. Is this possible and is it relatively easy? The database doesn't have to create the shifts, they will be imported from Excel....

Which leads me to believe I need to think of it differently to excel... Attached is an excel rota, which would need to be importred - but maybe I need to be think a lot differently.

I know thats a big question but any help would be appreciated, or pointers to more resources... Thanks
Neil

Ever tried Outlook?

Haha - well... we dont use outlook at work.... and it's getting to be a pain with Excel....

If you do a google search I am sure there are templates which do much what you are looking for

This forum has had several threads on general scheduling, timesheet management, and personnel appointment tracking. Try searching this forum for keywords

schedule
Timesheet (and time sheet)
appointment

Scheduling is ambiguous in English vs. Windows because it is multi-valued. So when reading any of the threads on that topic, if it seems to be talking about how to make an event happen at a specific time, that is the OTHER use of the word scheduling and is therefore no relevant to your problem.