Share via

Timesheet Database Design Help

Anonymous
2013-02-07T14:37:22+00:00

Hi

I need to create a Time Sheet Database, but I'm new to Access and can't quite work out how to get the desired results.

The Database i need to create requires a form for inputting Employees (also requires a table right?), a form for inputing Time sheet: Employee (Lookup), Project, Hours, Date, and Description.

The Database also requires a user friendly GUI for the forms.

Lastly i need to be able to get a report per employee for the whole week, this would be the data from the time sheets down as Monday-Sunday etc in a table, with a second table below with Project, hours per day on project, and total hours for the week per project.

I can't read/write Visual Basic, and i don't know how to use Macros or expressions.

If any one can help me out with this i would be grateful.

Thanks

Matt

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

14 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-02-07T16:25:42+00:00

    Thanks for your answer, I have done a foundation course in access but it only covers how to create components, tables, forms, queries reports etc.

    It's more i don't understand how to get them to work together if this makes sense?

    For my Database is it possible to do without VB, Macros and Expressions or do i need to find that out as well?

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-02-27T14:56:17+00:00

    Would anyone be able to go through this step by step with me please?

    I think from what Scott said I have an idea of how to do it but I would greatly appreciate it if someone could go through the various stages for me, if at all possible.

    Thanks

    Matt

    2 people found this answer helpful.
    0 comments
  3. ScottGem 68,810 Reputation points Volunteer Moderator
    2013-02-28T16:16:22+00:00

    FK stands for Foreign Key. Tables are generally related from PK to FK. So yes you want to link by EmpID. Date is a reserved word in Access so shouldn't be used as an object name, so you change that to something like LogDate. You also need another table:

    tblProjects

    ProjectID (PK autonumber)

    ProjectName

    You should then change Project in tblTimeLog to ProjectID as a FK and join those 2 tables.

    Your next step is to build a form bound to tblTimeLog. Use comboboxes so you can select the Employee and Project.

    1 person found this answer helpful.
    0 comments
  4. ScottGem 68,810 Reputation points Volunteer Moderator
    2013-02-27T15:54:31+00:00

    Start off with designing your tables. For example:

    tblEmployees

    EmpID (PK Autonumber)

    Lastname

    Firstname

    other employee info

    tblTimeLog

    TimeLogID (PK Autonumber)

    EmpID (FK)

    TimeIn

    TimeOut

    1 person found this answer helpful.
    0 comments
  5. ScottGem 68,810 Reputation points Volunteer Moderator
    2013-02-07T16:39:34+00:00

    It is certainly possible to create a nice Access app without resorting to writing any code (either VBA or macros). You may have to use the wizards to generate some code for you, but that's easy enough.

    But the question is who is this app for? If it is for employees to enter their time, you may need to use code to secure the app, prevent unauthorized changes, automate processes etc.

    But if you follow the table structure I suggested. You should be able to use the Form Wizard to create a form for employees to enter their time. Use comboboxes for the employee to enter their name and project.

    You can then create the queries and reports you need using the other wizards.

    1 person found this answer helpful.
    0 comments