help me design database to track time
Posted on 2011-10-11
I am looking for tips and suggestions in designing a database to track and calculate my time at work. I have 0 experience working with access. I have been using excel to document what I do throughout the day, but am not really able to calculate how much time i spend on what. I am thinking I can have a table that groups tasks into a hierarchy, if that's possible. I have two roles at work so I would like to originally divide the tasks into three main groups one for each role and one for administrative tasks (cleaning the office, etc.). Then I would like to to further divide the tasks if possible on a few more levels of a hierarchy. Not sure what the best way to do this would be. I was thinking to create weekly time sheets where I could use a form to enter my time spent per task.