PC Review


Reply
Thread Tools Rate Thread

Access Database to Track Employee Times

 
 
Chris
Guest
Posts: n/a
 
      15th Dec 2009
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.
 
Reply With Quote
 
 
 
 
Dorian
Guest
Posts: n/a
 
      15th Dec 2009
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".


"Chris" wrote:

> 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.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
database that can track employee insurance benef Julie Censke Microsoft Access 3 4th Feb 2009 06:33 AM
Does anyone know what happened to the Access Employee Database BKB Microsoft Access 0 13th May 2008 04:33 PM
need help designing a database (Access) to track employee training =?Utf-8?B?T2x1IFNvbGFydQ==?= Microsoft Access Database Table Design 0 23rd Jun 2006 06:55 PM
Employee Database in access =?Utf-8?B?QWNjZXNzIEVtcGxveWVlIERhdGFiYXNl?= Microsoft Excel Misc 6 8th Nov 2005 06:57 PM
How would I track tuition reimbursement by employee in Access? =?Utf-8?B?SUFNSFI=?= Microsoft Access 1 18th Aug 2005 12:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:19 PM.