Completed

Wage System in Ms Access or OpenOffice Base - 23/07/2016 22:16 EDT

Each week we pay employees based on how much worked have done, We use excel and the task has become hard manage and match all the data. We need help with creating to database based App to reduced work load. It is very simple nothing complex.

I have attached a sample excel which we create, The employees is given a Issue ticket which has ticket number, Model number, quantity, Employees name. At the end of the week we collect the ticket and enter them in excel. Sometime we have more then 200 tickets which is very consuming process to enter in excel and veirfy and cross again mistakes or over payment. Then we also have to deduct the adv money given to the them.

We don;t want any complex System this works well, Just need help Streamlining it.

Form 1 Employee Adv; Which will all us to enter adv amount which is to be deducted from there payment

Form 2 Department: which will allow us to enter and new department, if we need to any new department. It maybe help to add sort code which will display department in order we want on the reports

Form 3 Model Rates: This all to Add New, Edit Model rates, A search by model number will be helpful. ( there are over 500 models ) Not all model have all department, 1 model might have singer, Overlock only other might have Singer, overlock, Flatlock, Press and so on. Also i am not sure but when new department is added how will have effect table.

Form 4 Ticket entry: This form will allow us to enter all Issue ticket data;:::::: Date, ( which be today's date but can be changed if wanted) Select employee, Maybe a sub form from here for fast entry, All ticket are entered at the same time for same employee, So one person tickets are entered and then the next and next. Ticket Number, Select model number from drop down; enter quantity which you select model the rate is already pulled from the rates table and which ever department they are assigned.

Report 1: Detail of all employee along with there ticket number name department item referee quantity rate amount and total and deduct adv and final total.

Report 2: Detail summary of model and departments, See attachment.

Report 3: Summary of all employee with there totals, adv amount, and in hand pay. See attachment.

All of the table and sample excel sheet is attached.

If you have any questions please let me know.

Compétences : Développement de bases de données, Programmation de bases de données, Microsoft Access, Bureau Windows

en voir plus : wanted employees, wage works, singer 22, pay entry base data, ms access form data entry, ms access data entry form, how to process the data base, how to create data entry form in excel, how to create a data entry form in excel, how to create a data entry form in access, data entry wage, data entry in ms access , creating a data entry form in excel, creating a data entry form in access, create data entry form in excel, create data entry form access, openoffice access, web base student registration grading system software university, vb net access system samples programming, simple system ms access

Concernant l'employeur :
( 2 commentaires ) Decatur, United States

Nº du projet : #11086369

Décerné à:

sunny945

Hi There! I am a professional Software and Database developer and would like to work on your project. I can make you a software to manage your employees wags. I have some very good ideas for your management software Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 10 jours
(25 Commentaires)
5.5

18 freelance font une offre moyenne de $439 pour ce travail

Prashantskin

[login to view URL] I have gone through your project requirements. I have also gone through all your attachments. I will develop your wage system in access with all the forms and reports you have mentioned. I will convert th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(532 Commentaires)
7.3
branislavm

Hi! You are correct, this is better suited to the database than to Excel. I've worked before on several similar systems, usually those were part of the other programs (like the program for restoration service). I do Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(206 Commentaires)
6.9
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database about work tracking. I have 7 years’ experience designing and developing Access databases. I would approach your project Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(96 Commentaires)
6.6
cgullapalli

Hi, I am good at Excel and Access. I can see there is a good scope with excel itself. May be shall i make better Excel? or u want to go with Access only. I have seen the attachments. Hopefully, a quick voice chat Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(27 Commentaires)
5.4
royalcalif

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. [login to view URL] Pm me for more information and sa Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(52 Commentaires)
5.6
jawadaman

Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(70 Commentaires)
5.6
zu02

Hi there, I viewed your "wage system"... if you'd like to have a professional Ms Access(if need with Excel automation) DB, here is my introduction: I’m an Access/VBA coder, a mathematician and a full time de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(45 Commentaires)
6.1
lavizsolutions

Hi, I have gone through your process , i can provide you browser based app, can run on local or as well web. [login to view URL] tracking System, below is the admin panel to manage all the operations. nice part is report Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(2 Commentaires)
5.0
mrrapp

Hi, I have been an independent Access programmer in New Jersey for the last 20 years. Access is all I do, full-time. Hence I work quickly and efficiently and have a lot of great ideas from all the projects I have wo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(6 Commentaires)
4.7
AlexandrUKR

please clarify possible next steps & deadlines .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(12 Commentaires)
4.5
P0L

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)
4.7
crypthne

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(29 Commentaires)
4.4
dgled

Hi, If you want I can do this job in excel, including tables (employees, models, advance payments) screen layouts to enter the information and report generator to see the results. I am a specialist in financial repor Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(3 Commentaires)
4.2
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
2.1
sergioobici

I will work on Ms Access. I can start the project from the first of August, if you can wait I'd be glad to do a good work for you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.6
Zealous1987

Hello, I am Mangesh Shinde and I have read your requirement for your wage calculation system and the attached excel. I am an experienced software developer. I have experience in development of invoicing and accounting Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
CloudLogics

HI I am expert in Access Databases. I saw the attached files. I have done similar projects. I can do this efficiently. Ready to start. s k y p e [login to view URL] Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0