time sheet management database

[Rachael]

I am new to access and was wondering if it could be used to record time spent
on files.

In my job all my "time" must be billable to a "file". It is in 5 minute
increments. I may work on the same file intermintantly throughout the day, 5
to 15 minutes, here and there.

I need something that will total up the total time spent on all files in a
day, as well as the accumulative time over a week, sorta like a spreadsheet
chart.

M T W T F S S
12345-Joe 1:00 0:10 0:45 etc...
12345-Jane

I also need something that will read the chart and take each file
number/name and total all the time spent on that file for a two week period.
It would need to go on a separate sheet something like this:

Date File name/number time spent Signature
Jan 1, 2005 12345-Joe 1:55 JDoe
Jan 2, 2005 12346-Jane etc....

I would like to be able to have a query of some sort so that a box pops up,
I enter the file number, date, and time, and it will put it in the time
sheet. But I also want it to be able to read the file number I enter, and
total the time for that day. So, if I go in twice in one day, I enter the
same file number and day, I want it to ADD the time, not make a new entry.

Is this possible? How hard would it be?

 

[Duane Hookom]

When designing tables to store information, disregard how you want the
information to appear in a report. I expect you will need to store your
billable records in a table like:

tblBillableWork
================
BillWrkID
FileID link to primary key of table of files
EmpID link to primary key of table of employees
(I assume you have a record in this table)
WorkMinutes Number of minutes worked on file

You might need to add a field for StartTime if that is significant.

 

[Ed Warren]

You can do what you want with Access, A very easy way is to use the Journal
options in MS Outlook.
Take a look at Journal in the Outlook help file. This will capture the
time, then you can export this to excel and/or access and run a total to get
the hours.

Ed Warren.