help me design database to track time

Posted on 2011-10-11
Medium Priority
Last Modified: 2012-05-12
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.
Question by:italo5696

Assisted Solution

speak2ab earned 668 total points
ID: 36950158
Personally, I would suggest using excel to handle this. I believe the process should be easy enough for  excel to handle and save you the complexities. If summing up the hours is the issue you have with excel, you might want to google or use MSExcel help files to see how to sum up the row for time spent per task.

However, if creating a database is the way you will like to go, I would say you can really customise things to suit your specific needs than excel. For the scenario you mentioned above, I will give you a sample database table design that you can use and direct you to a link that can help you tie all the knots together.

First, you will need a table with the following fields. (Note there are several ways you can achieve thesame thing)
Start Time

With this you can create a form in Access and you can generate reports easily.

Check this links to get started:
http://databases.about.com/od/tutorials/Tutorials.htm and


LVL 93

Accepted Solution

Patrick Matthews earned 668 total points
ID: 36950552
The following template is available via free download from Microsoft:

http://office.microsoft.com/en-us/templates/results.aspx?ck=1&ex=2&qu=access time tracking&av=all#ai:TC101898281|

If that URL does not work for you for any reason, go to the office.com home page, click on templates, and in the search templates box enter:

Access Time Tracking

One of the results that will come up is a time tracking template.

Chances are that it will get you 80% of the way to where you need to be.
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 664 total points
ID: 36951975
Just be aware that the Complexity of your design will increase with each "level of a hierarchy" you create.

L1TaskID (Primary Key)

L2TaskID (Primary Key)
L1TasksID (Foreign Key)

L3TaskID (Primary Key)
L2TasksID (Foreign Key)


So you may just want to stick with two levels for now... (The main level and one lower level)

This gets even more complex if one child task can be assigned to more than one parent task...

Just FYI...


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question