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.

Kemahiran: Pembangunan Pangkalan Data, Pengaturcaraan Pangkalan Data, Microsoft Access, Destop Windows

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) Decatur, United States

ID Projek: #11086369

Dianugerahkan kepada:


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 Lagi

$250 USD dalam 10 hari
(25 Ulasan)

18 pekerja bebas membida secara purata $439 untuk pekerjaan ini


[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 Lagi

$333 USD dalam 3 hari
(532 Ulasan)

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 Lagi

$555 USD dalam 10 hari
(206 Ulasan)

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 Lagi

$300 USD dalam 7 hari
(96 Ulasan)

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 Lagi

$600 USD dalam 5 hari
(27 Ulasan)

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 Lagi

$300 USD dalam 6 hari
(52 Ulasan)

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 Lagi

$333 USD dalam 10 hari
(70 Ulasan)

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 Lagi

$555 USD dalam 10 hari
(45 Ulasan)

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 Lagi

$1000 USD dalam 25 hari
(2 Ulasan)

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 Lagi

$400 USD dalam 10 hari
(6 Ulasan)

please clarify possible next steps & deadlines .

$1000 USD dalam 30 hari
(12 Ulasan)

A proposal has not yet been provided

$300 USD dalam 3 hari
(15 Ulasan)

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 Lagi

$250 USD dalam 7 hari
(29 Ulasan)

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 Lagi

$555 USD dalam 10 hari
(3 Ulasan)
$250 USD dalam 2 hari
(2 Ulasan)

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.

$388 USD dalam 10 hari
(0 Ulasan)

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 Lagi

$288 USD dalam 4 hari
(0 Ulasan)

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.

$250 USD dalam 10 hari
(0 Ulasan)