help me design database to track time

Posted on 2011-10-11
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
    LVL 5

    Assisted Solution

    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: and


    LVL 92

    Accepted Solution

    The following template is available via free download from Microsoft: time tracking&av=all#ai:TC101898281|

    If that URL does not work for you for any reason, go to the 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
    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...


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now