S
SMBR
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.
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.