Hi all, I have been lurking around on this forum for a few months now and have learned quite a bit, but now I have some questions of my own. I am pretty new to Access, and all I know of it so far has been self-taught in a sort of learn it as I need it approach. I don’t know much about database design and normalization yet.
I have been given the task of designing a database for keeping track of employee’s daily time sheets and the tasks they were working on during that time, and I’m not quite sure what would be the best way to go about it.
So far, my plan is to have a table for employee data, another with a list of tasks and the teams they are assigned to, and a 3rd for the time sheet entries. To keep track of their time, employees will use a form to enter a start time, end time, use a combo box to select the activity they were working on during that time, and the quantity they completed. There would be multiple entries like this for each day.
So, something like this:
Employees
NetworkID
FirstName
LastName
Supervisor
Team
…Etc
Activities
ActivityName
Team
TimeDetail
NetworkID
WorkDate
StartTime
EndTime
Activity
Quantity
My goal is to have the data in a format that will allow me (and management) to easily look at what each person did on a daily basis but also to see a breakdown of their statistics (time spent/quantity per activity) on a weekly or monthly basis as well.
Does this seem like a decent way to organize the tables and data or am I going about it all wrong? If not, why not and what would you do differently?
I have been given the task of designing a database for keeping track of employee’s daily time sheets and the tasks they were working on during that time, and I’m not quite sure what would be the best way to go about it.
So far, my plan is to have a table for employee data, another with a list of tasks and the teams they are assigned to, and a 3rd for the time sheet entries. To keep track of their time, employees will use a form to enter a start time, end time, use a combo box to select the activity they were working on during that time, and the quantity they completed. There would be multiple entries like this for each day.
So, something like this:
Employees
NetworkID
FirstName
LastName
Supervisor
Team
…Etc
Activities
ActivityName
Team
TimeDetail
NetworkID
WorkDate
StartTime
EndTime
Activity
Quantity
My goal is to have the data in a format that will allow me (and management) to easily look at what each person did on a daily basis but also to see a breakdown of their statistics (time spent/quantity per activity) on a weekly or monthly basis as well.
Does this seem like a decent way to organize the tables and data or am I going about it all wrong? If not, why not and what would you do differently?