I’m trying to set up a small Access database with forms/reports for helping someone track sick and annual leave time. Basically, she wants to have a datasheet form showing all employees where, after every 2-week pay period, she can enter the leave time that each employee has taken, and that form will also show her (dynamically) the amount of leave accrued during that same period and what the new balances are for each employee. A second form will also be required which will show each employee as a separate record, with name, contact info, etc., plus a subform showing their leave history across all pay periods (including the running balance, like a checkbook with debits and credits).
She should be able to edit the leave data from either form.
I think I need 4 tables – employees, sick time, annual time, and pay periods – but I’d appreciate some thoughts regarding a good way to go about this table structure, table relationships, etc. – especially if anyone has done this kind of project before.