I have been tasked with creating a DB to record work completed by team members on a daily basis.
This is to help see how are days are being spent on different projects.
I thought about a download, but couldn't think of the correct search criteria to find one
I want to record Staff Name, Date, Project Name, Project Sub Area & Time Spent
Would you create this as 1 table or many?
On any day 1 member of staff could be juggling several projects, so need to be able to enter data on a form for each of them.
This is to help see how are days are being spent on different projects.
I thought about a download, but couldn't think of the correct search criteria to find one
I want to record Staff Name, Date, Project Name, Project Sub Area & Time Spent
Would you create this as 1 table or many?
On any day 1 member of staff could be juggling several projects, so need to be able to enter data on a form for each of them.
