HR & Admin Data Tables

[mba_110]

Hi Everyone,




I need help to create HR & Admin database in MS Access for my small business and i need help to create tables with appropriate labels and categories.


Here is some details that i am going to do in MS Access.


Employee Employment details, i have about 100 employees.
Employee payroll
Employee's Increment records
Simple entry form for all records with drop-down menus with options
Employees Annual Leave entitlements with various calculation methods (every employee has different contract with yearly or each two year leave etc)
Employees End of Service benefit Accruals,Payments & balance as per selected dates, with different calculation type etc.
Various reports as per the requirements.




I want help creating tables with data inside to be linked properly for all above requirement


Thanks & regards,


MBA

[June7]

See if working through tutorials at http://www.rogersaccesslibrary.com/ will get you on right path. Create and ERD and post it if you want it reviewed. Or see if an OTS app like QuickBooks will meet needs.