I need to create a database that will contain work schedules for several departments. I need to schedule them a month at a time, note when someone calls in and who worked in their place, I need to do some detailed reporting to help with budgeting and OT cost. Our current payroll system does not provide me with the options above. I can only see when they actually worked and history.

I need to pull for a month, pull all the people that work within a certain department and then enter the schedule (hours working 7a-7p and location started - main entrance, ER entrance). I want the names to the left, days of the month across and then hours/location going across under the day.

I would attach an example but I am new to this site and I do not see an attachment option.

Thanks,
Deborah

Deborah,
This is what I suggest. Planning a db design is like
visualizing yourself doing manually. When you think of a way to do it manually, then design it to a database. I do first creating an excel spreadsheet where you have columns and rows. My rule is the first rows are the column headings and the first column is the primary key or record no. (starting fr 1 to num of records).
In your database what is important are datas and the data types of each data. Then for each tables with datas next is the relationship with those tables.
In your database create the following
tables (lets do it by heirarchy):
1) Year (yyyy)
2) Month ((mm)
3) Day (dd)
4) Time (hh:mm)
5) Employee
6) DS (Daily Schedule) related to all the records above.
In Access, make use of the crosstab query and create a report from
this query.
I hope this helps. Good luck.
jm