Timesheet Form

S

Speedy

I was wondering if anybody had designed a form for timesheet capture which
shows the week in a grid format and then allows the user to input the hours
worked per day and per client?

Thanks for any assistance.

SPeedy
 
A

Arvin Meyer [MVP]

That's more in the realm of a spreadsheet. To do it that way in a database
is possible, but not without violating relational database Normalization
rules.

To properly design a database for that structure a simple table with 4
fields is required:

EmployeeID
DateWorked
HoursWorked
ClientID

To complete that structure, an Employees table and a Client table would also
be required.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
S

Speedy

Hi Arvin, thanks for the reply.

I don't totally agree with you though. The data is normalised in that the
data that will be saved will be that used in the MS Access sample time ledger
application provided with the system.

What I want to do is to have a different presentation to work with for the
input which as you say is like a spreadsheet. The reason for this is that we
need to have certain controls and checks done before we update the database.
For example we want to check to 8 hours are accounted for any particular work
day and that the total for the week is 40 hours.-

The use of a spreadhseet like grid makes this easy and I have seen this
feature on some commercially available high end systems.

None of these checks are needed to be captutre they are really only input
time validations checks.

The other thing is to have a calendar like grid to help with a visualisation
of the whole week as timesheets are completed weekly in arrear.

Cheers,

Speedy
 
A

Arvin Meyer [MVP]

You can output the work in a crosstab query and use a report to display
totals without entering data that way. I realize that the spreadsheet format
appears to be a solution, and it is if you are not ever storing the data for
recall at a later date and combining it into summary reports (monthly,
quarterly, yearly, etc.) or reports which compare the data for different
periods. But if you ever want to use the data you need to store it
normalized in the manner I showed.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top