Best approach for Absence DBase

[JohnMc]

I’ve been given a brief to build a database (after sometime away from access) to record and monitor staff absences and in the whole it’s a straight forward task however I’ve hit a wall in how to proceed with the actual absence tracking:

The issue I have is:

I have multiple offices eg- Office1, Office2, Office3 etc
And
Multiple absence types eg – Sick1, Sick2, Sick3 etc.



Now Office1 treats Sick1 differently in that after 4 days an action is need and after 8 days another.
Office2 has an action needed after 8 days and after 12 days
Office3 has and action after 10 day.

What I need help with is some pointers in how to tackle the problem, whether it’s through Queries, reports etc – not really sure where to start – any help greatly appreciated.

[pdebaets]

Do you have your tables designed and normalized? That is always where you start when creating a database.