Access Timesheet Application

[Guest]

I've seen tons of posts in here from folks needing to build a timesheet
application in Access. I'm one of 'em. Once I saw a link to something
homemade one of the forum moderators has come up with, but after two days of
searching, can't find it again.

Excel seems to handle this task most elegantly. However all of our travel,
project and billing information is stored in Access. To execute true Project
Reporting/Analysis, we need a timesheet in Access as well.

Now, I haven't a clue about Pivot Tables and such and I'm hoping that the
solution is in that last untamed Access wilderness on the frontier of my
database development career.

Anyone have any suggestions on where to "begin" with a complex timesheet
application?

Thanks!
/amelia

 

[Guest]

You got it...the solution is out there in that untamed Access wilderness...if
you ever get it tamed, let the rest of us know...

For starters, just try to break the process down into discrete elements &
get your table structure put together. For a VERY simple example:

Employee table with these fields:
EmployeeID (AutoNumber)
LastName (Text)
FirstName (Text)
SSN (Text)

Project table with these fields:
ProjectID (AutoNumber)
ProjectName (Text)

Timesheet table with these fields:
EmployeeID (Long Integer with relationship to Employee.EmployeeID)
ProjectID (Long Integer with relationship to Projects.ProjectID)
StartDate (ShortDate)
StartTime (ShortTime)
EndDate (ShortDate)
EndTime (ShortTime)

etc.

Once this is done, the next step is to make a Employee and Project forms to
set up your list of employees/projects. Then, you set up a Timesheet form
that draws from both of the above and adds the specifics.

I am sure you will have more specific questions when you get there.

 

[Guest]

i have tried:
T_PROJECTS:
T_PROJECTS.ProjectID (Autonumber Primary Key)
T_PROJECTS.ProjectNumber (number)
T_PROJECTS.ProjectName (text)

T_EMPLOYEE:
T_EMPLOYEE.EmployeeID (Autonumber Primary Key)
T_EMPLOYEE.FName (text)
T_EMPLOYEE.LName (text)

T_TIMEREPORT:
T_TIMEREPORT.ReportID (Autonumber Primary Key)
T_TIMEREPORT.Employee (T_EMPLOYEE.EmployeeID)
T_TIMEREPORT.Month

T_REPORTDETAILS:
T_REPORTDETAILS.ReportID (T_TIMEREPORT.ReportID)
T_REPORTDETAILS.WorkDate (date/time)
T_REPORTDETAILS.Project (T_Projects.ProjectID)
T_REPORTDETAILS.Task (text)

....in a Form/Sub Form set up