Find Jobs
Hire Freelancers

Manual Excel Time Sheet entry & report generation to VB with Access Database

$10-30 AUD

Dibatalkan
Dibuat lebih dari 8 tahun yang lalu

$10-30 AUD

Dibayar ketika dikirim
Hi Guys, Basic background:- I have a manual Time sheet in excel, which is filled weekly by team of 11 members individually and sent to me for further approval. And then I require checking each of them, and copy paste the data in separate excel sheet for final report. Requirement:- a very friendly user-interface front end interface with VB Winform and Backend Access database can be stored somewhere on company local drive, that includes login (employees will only be able to see and update their own records), and an easily expandable application, provide the administrator with his own front-end interface In which I can add fields to the form(if possible). This interface will enable the administrator to access the database and integrate multiple time sheets with a few clicks. I will be able to print out the required reports and lock time sheets to prevent further updates once approved. Access would also allow for multiple users to use the application simultaneously. There will NOT be multiple databases; it is only one that employees can reach through their front end application. For each week entry, individual have option to update their previous entered data in case if they missed something or updating the entry , each one of them will be able to add/edit his own TimeSheet . Need Employee ID and Name as compulsory or will auto fill when employee logged in. The report should be generated without duplicate entries. Back end should be secure with restricted access to myself or the person i wants to add. There are some validations and auto calculations require with form or excel sheet. Like- option to select normal day/public holiday, Day shift/afternoon shift, When normal day selected and worked time entered - after ordinary hours 7.60 hrs ( formula is provided in excel sheet) , it auto fill overtime hours if worked hours more than 7.60hrs First 3hrs overtime filled in overtime x1.5 and rest will go to overtimex2. If public holiday selected all the no. of hours worked will be goes to back end data as public holiday X2.5, If afternoon shift is selected, the loading will be 15% for all the hours if shift finished after 7pm. and few bits and pieces as we build it. If you can make front end look similar or better then excel sheet, that will be good. Anything you think will easy my task and employees as well can be added, In addition if you can please provide me with all the Files, design and coding and a bit run down to tweak few things in form and database. Should be able to do few minor updates on this , don't worry won't be asking much as this is just simple entry and report generation thing. Please provide first release ASAP as you can. Happy Bidding THIS IS a FIXED Price Project Max $50, So please bid around the budget mentioned.
ID Proyek: 8076701

Tentang proyek

14 proposal
Proyek remot
Aktif 9 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
14 freelancer menawar dengan rata-rata $149 AUD untuk pekerjaan ini
Avatar Pengguna
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$400 AUD dalam 7 hari
4,9 (204 ulasan)
7,3
7,3
Avatar Pengguna
Hey, What you are looking for can be done from within excel itself. Is it necessary to use VB Winform as you mentioned in your bid. I could use that but it is too cumbersome for the users. Moreover, your users already have the excel template (like the one you attached) and I am assuming they are comfortable working with it. I have done similar setup for a POS system where the database in one one of the computers in the store and users do not have direct access to it. They routinely access and update data (only though their respective front-ends in excel) and the store manager can generate reports. I can create a similar setup for your purpose and can ensure that users would only be able to interact with the data within the defined boundaries and you would be able to generate the report. All users including you would only need to click a few buttons to work with this system saving many man-hours every week. Does this sound interesting? Do let me know and we may discuss the details. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$333 AUD dalam 7 hari
4,9 (114 ulasan)
6,5
6,5
Avatar Pengguna
Hi there, I've been working with Ms Office (especially Excel, Access) since before year 2000. I have few years of experience working with macros and writing / debugging VBA code. I have previous experience on similar data entry projects and with great reference from previous employers. Good English knowledge and technical skills and vocabulary can be considered a plus. What you need it cannot be done in 1-2 days. It will require effort for at least one week - and also from your side, to test and provide feedback that everything works as expected. I have previously have worked with employers New Zealand and Australia and I know that time zone could also be an issue... that can add some delay in our communication. But if really want to give it a try do not hesitate to contact me for further details. Kind Regards, Jon
$500 AUD dalam 12 hari
5,0 (35 ulasan)
5,0
5,0
Avatar Pengguna
Hi, I am 12+ years experienced Visual Basic,ASP.NET, VB.NET,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,XML,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company. I have 12 members Microsoft technology Developer. Already I have developed this kind of accounting software. If you want I can show you the demo. Let me now when can we discuss.
$400 AUD dalam 7 hari
4,9 (15 ulasan)
4,7
4,7
Avatar Pengguna
hello!!! Looks like a really easy project... Please contact me to chat on details about your requirements.. It has to be Access database?? greetings
$50 AUD dalam 5 hari
5,0 (8 ulasan)
4,0
4,0
Avatar Pengguna
Hello, You certainly need perfect and top translation. I'll do that for you as I'm an Arabic native speaker and English Specialist. My Arabic language is standard. I have a long experience (30 years) in various translations. I can format translation in accurate Arabic and formal English. At the same time I am good at data entry as I used to deal with Microsoft Office and also web research. My talent is in MS Word. - My rate $0.01 per word.
$30 AUD dalam 3 hari
5,0 (12 ulasan)
4,0
4,0
Avatar Pengguna
Hello , my name is Giolisbeth Cuevas , I am statistical / programmer, with over 7 years experience. If you choose me as your freelancer, you have a professional who has advanced knowledge of Excel , VBA, Macros , SQL , Access, SAS , SPSS, Eviews , certified and meets your needs. You do not hesitate to contact me I will Attend and clarify any questions you have . Thank You. Spanish Hola, mi nombre es Giolisbeth Cuevas, soy estadístico/programador, con más de 7 años de experiencia. Si, me elige como su freelancer, tendrá a un profesional, que tiene conocimientos avanzados en Excel,VBA, Macros, SQL, Access, SAS, SPSS, Eviews, certificada y que se adápta a sus necesidades. Tu no dudes en contactarme, yo le asistire y aclararé cualquier duda que tenga. Gracias
$25 AUD dalam 3 hari
5,0 (1 ulasan)
2,0
2,0
Avatar Pengguna
A proposal has not yet been provided
$25 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I am an Administrator with good typing, data processing and analytical skills. I am able to import, clean, transform, as well as validate data with the purpose of understanding or making conclusions from the data for decision making purposes. I offer my services 7 days a week at very affordable rate with a prompt turn-around time. If you would like more information, please contact me
$25 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$30 AUD dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$25 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
springvale, Australia
5,0
46
Memverifikasi Metode pembayaran
Anggota sejak Sep 8, 2014

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.