You have chosen to sponsor your bid up to a maximum amount of .
I need a MS Access payroll db that pays its employees in 3 different ways. By Salary, Hourly and Commission. I do not need any complicated deductions. I just need a main employee table and 3 id dependent tables (Salary, Commission, Hourly). Then I need a Payroll or Timesheet to generate the payroll. The design is up to you. The premise of the DB is for a small automobile dealership that pays its employees
Commission (salesman (who receive a certain percentage of each sale) Hourly (mechanics, secretaries, lot attendants ect..who are paid hours worked * rate) Salary (owner, managers ect....) you may need a table for sales to keep track of sales made by the salesman that has a relationship to the Commission table. Lastly a Payroll table to generate either the bi-weekly or monthly pay. Then I need simple sql queries to access data and forms to create or enter data. This need to be a very simple db and I am giving the designer the liberty to design as they see fit. I am giving you a logical conception of what I need. I need to first understand you know what I require