Need Database Design Advice

[Guest]

I have been assigned a task to create a database and need some advice on the
correct design. I am not new to Access, but nowhere near an advanced user.

The database needs to hold labor hours required for each of our projects.
The labor for each project is broken into Foreman, Service Tech, and
Laborers. The labor hours are recorded by months so each category (Service
Tech, etc.) will list labor for each month of the year over the next 3 years.
I am thinking that the best way to set it up is to have a separate table for
each labor category per year. Service Tech 2005, Laborer 2006. etc.

I have no idea if this is the best design. Any help is appreciated.

 

[Duane Hookom]

I would create a table with a structure like

tblProjectLabor
=================
PrjLabID autonumber primary key
ProjectID foreign key to table of projects
LaborCatID foreign key to table of labor categories
PrjLabDate date/time field to store the beginning date of the month
PrjLabHours numeric field to store the number of hours of labor

I would definitely avoid creating separate tables for each year or each
category of labor.