Access Database to Track Employee Times

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Yesterday I had posted a question to see if anyone had an Access database
that tracks employee times, very similar to a time clock. What I would like
is to have a form that has all of the buttons on (Login, Break 1 Out, Break 1
In, Lunch, etc.) and when the user clicks these buttons, the time will be
logged into a table. I would then like to report ONLY the times a person
does not meet the rules of logging in, break times, etc. For example, if an
employee clicks the login button anytime after 8:05 AM, I would like that
time to first be copied to the master time table, and then also be copied to
some sort of reporting table to show them getting "dinged" for being late.
The same would hold true for the others. Breaks are only 15 minutes, so
anything after that would get reported.

Is this possible in Access? Does anyone have an attachment of a database I
could use or point me in the direction of a database with a link?

I appreciate it. Thanks.
 
What is the purpose of this system?
Personally, I think you'd be far better off in designing a system to detect
how productive workers are when they are working rather than just measuring
'time on the job'. I'm not sure what type of workers these are but where I
work some of the workers who arrive and leave on time are the least
productive.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top