Staff Duty Absence / Presence Table (1 Viewer)

smatipu

New member
Local time
Today, 03:12
Joined
Aug 20, 2019
Messages
2
Hi,
I want to track record of my 300+ staff member and want to design table and form to track daily Presence / absence of that staff which is working on three shift. What should be the table design scenario and form scenario in order to get this job done please..

Waiting for your positive response.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 10:12
Joined
Feb 19, 2013
Messages
16,553
basis design might be

tblEmployees
EmployeePK
EmployeeName

tblInOut
InOutPK
EmployeeFK
ClockIn
DateTime

However this very much depends on how your employees clock in and out and how you want to handle scenarios where they forget to clock in or out, what you want the data for etc (i.e. what does 'track daily presence' really mean).
 

Minty

AWF VIP
Local time
Today, 10:12
Joined
Jul 26, 2013
Messages
10,353
At the simplest level you'll need at least 2 tables Employees, TimeRecords

At a very simple level simply record the time and the activity and employee ID

EmpID, EventDateTime, EventTypeID

The event type should probably come from a third table tblEvents, and would be have records for SignOn, SignOff, LunchStart, LunchStop etc. You can then calculate the time spent between events.

You could have a start and stop time per event, but that can lead to issues within queries and needing to make sure you updating the correct record.


Edit: CJ has faster fingers...
 

Users who are viewing this thread

Top Bottom