Hi,
I am trying to create a database for daily attendance. Can some please help me in starting how should i design my database. I want an automatic table to be created every month. I should be able to record attendance for each day for each employee.
All this should take place with entry in a form. I am planning to use following five options:
a) Present
b) Work from home
c) Leave
d) Holiday
e) Non Working Day
In case of leave, three options will be available - Approved/Unapproved/Pending for Approval. Something like, a particular day is marked as leave for an employee, so these three options will get activated.
My major cause of concern is automatic switch to next month + updation of employee records.
Any information on how to start would be of great help.
Thanks
Aman