Employee Time Database - HELP

[Spencer]

Can someone please point me in the right direction on
designing a database to track employee time in Access?
This will replace a time card system. I want to be able to
track the time and divide the hours into quarters
automatically for payroll purposes.

Thanks in advance for the help

 

[Tim Ferguson]

Can someone please point me in the right direction on
designing a database to track employee time in Access?
This will replace a time card system. I want to be able to
track the time and divide the hours into quarters
automatically for payroll purposes.

Sorry to ask but... will you be one of the employees whose correct pay
depends on this thing running right?


Tim F

 

[Joe Fallon]

I wrote a punchcard replacement system using Swipe clocks to gather the data
and feed a SQL Server database.
I built an Access front end to it so Supervisors could do things like
approve overtime and edit incorrect (or missing) entries. Lots of reports. I
replaced the payroll generation routine (of the canned software) with a
procedure I wrote in Access VBA. Eventually we dumped the canned software
completely. The output file was fed to the AS400 as the input to the payroll
system. (The file replaced all the clerical keyboard work.)

It was quite a complex system and required months of effort to get running
smoothly.
If you don't have a lot of experience, I wouldn't try it yourself.

 

[TC]

Sorry to ask but... will you be one of the employees whose correct pay
depends on this thing running right?

Tim F

At least it wasn't a medical records system!

Spencer, if you're reading this, Tim is saying the following: If you aren't
familiar with relational database managements systems in general, & MS
Access in particular, then designing a payroll system will be a very big
ask. It is unlikely that you could do it first time, with no errors. So if
other people will depend on it for getting their pay, you might end up in an
unpleasant situation!

I would recommend that you get a book on getting started in Access. If the
book is too simple, you haven't lost much. But if you learn from the book,
this would prepare you for doing someting more complex (like a payroll
system). Searching this group for "books" will doubtless give you many
suggestions.

HTH,
TC