Table design

[Valiant]

Hi

I am trying to create an Access database to record timesheets for
individuals within my department. I am having difficulty trying to create
the table(s) for recording of the timecards. The scenario is as follows:

- each employee completes a timecard once a month. Each timecard has to be
unique to the employee.
- the timecard records, by half day, time spend against chargeable,
non-chargeable & other work.

How can you design the tables such that timecards per employee are
sequential (i.e. so you can see which months they have not completed) and how
would I consolidate the data by task / category, such that you can run
reports off on a period to date / date range basis? I have had a look at the
Microsoft example database, and it's not quite what I am after!

Very confused, so any help much appreciated!

 

[Duane Hookom]

A basic table design would be:

tblTimeSheet
=================
tsID autonumber primary key
tsEmpID link to employee table
tsDate work date
tsStartTime
tsMinutesWorked
tsProjectID link to table of projects
tsChargeable yes/no
tsWorkDescription

 

[KARL DEWEY]

would I consolidate the data by task / category
You did not relate "task / category" to anything. Are the subsets of the
projects or work descriptions like travel, inspecting, purchasing, assembly,
testing, writing, etc.?

 

[Duane Hookom]

I don't have a clue how you want to track task/category. If a task was
always part of a project, you could replace the tsProjectID field with
tsTaskID to relate to a task of a project. If category is type or work
performed, you may need to add a tsCategoryID field.