How to prepare a payroll using Access
Am trying to use Access to prepare a payroll as an assignment but the problem is I dont no the commands to use or how to do it.
This is how the calculation of TAX is to be done in the payroll;
CHARGEABLE RATE TAX CUMULATIVE CUMULATIVE
INCOME(MONTHLY) CHARGEABLE INCOME TAX
1.FIRST Â¢200,000 FREE NIL Â¢200,000 NIL
2.NEXT Â¢200,000 5% Â¢10,000 Â¢400,000 Â¢10,000
3.NEXT Â¢1,000,000 10% Â¢100,000 Â¢1,400,000 Â¢110,000
4.NEXT Â¢6,600,000 17.5% Â¢1,155,000 Â¢8,000,000 Â¢1,265,000
EXCEEDING Â¢8,000,000 @25%
TAX= 0.0 + 0.5 X (INCOME - 200,000)
TAX= 10,000 + 0.10 X (INCOME - 400,000)
TAX= 110,000 + 0.175 X (INCOME - 1,400,000)
TAX= 1,265,000 + 0.25 X (INCOME - 8,000,000)
CAN SOMEONE PLEASE HELP ME WITH IT?
THE FUNCTIONS AND EXPRESSIONS TO USE FOR SUCH A PROJECT.