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
Greetings Client
I have read your project request and will be able to help you with this project.
I have over 7 years of experience in Excel,Access and VBA tools,automation and database management and development.
I will provide you with quick and accurate project output
Regards
mukul sinha
I have done various access databases for people. I can even write a user friendly forms program for you if needed. Let me know I would appreciate it
Thanks Edwin Jeppe
hi
I have ten years experience on MS Access.
I have done seven Access DB for client in 2012
also I have five years in MS Access 2003 and Access 2007
I am sure I can do it well.
Btw: I were MVP about Microsoft Access in 2003
Bill
My understanding is this project need 3 forms : employee, sales/commission and time sheet which combine to generate the payroll.
I have experience developing various kinds of payroll system.
I use my self developed framework as front end with MS Access as backend database. With the framework, I can deliver with quality and on time.
Hi, I'm an experience MS Access developer and made similar database system related to yours. My recent work is mainly focus on MS Access Development and with 15 years of experienced you can be sure you get the best service, professionalism, and competency.