Annulleret

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

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 [url removed, login to view] 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.

System Update: MS access 2010 is only installed on one PC, rest team members have MS Office without Ms Access. So need some front end form which can interact in background with Access database, and generate reports in excel as per report sheet.

Evner: Regnskab, Excel, VB.NET, Visual Basic

Se mere: x2 design, which company need employee easily, vb data entry form, simple coding in vb, shift bits, duplicate data entry, drive time, design access database, data entry own hours, data entry form without excel, data entry application design, database administrator company, access database data entry form, microsoft access database data entry, video rental system vb access database, vb code create data entry excel, access database report invoices, access database order entry form, access database report, access database report html format

Om arbejdsgiveren:
( 46 bedømmelser ) springvale, Australia

Projekt ID: #8076701

14 freelancere byder i gennemsnit $149 på dette job

shikhamehta

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 alrea Flere

$333 AUD in 7 dage
(82 bedømmelser)
6.0
paris2785

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 Flere

$400 AUD in 7 dage
(51 bedømmelser)
5.4
JonNxt

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 sim Flere

$500 AUD in 12 dage
(35 bedømmelser)
4.9
acronymsolutions

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 Flere

$400 AUD in 7 dage
(15 bedømmelser)
4.8
WeirdMix

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 in 5 dage
(4 bedømmelser)
3.8
ENRICOJ

[login to view URL] A DATABASE DEVELOPER USING MS ACCESS AND VBA I WOULD LIKE TO ASSIST YOU. PLEASE,DO NOT HESITATE TO APPROACH ME FOR FURTHER ASSISTANCE .KIND REGARDS ENRICO.

$60 AUD på 1 dag
(2 bedømmelser)
2.9
balvant8127

3+ years of experience in vb.net application development. This type of task are my daily practice. I found everything complete in your requirements. Skype id : [login to view URL] Thanks.

$166 AUD in 7 dage
(1 bedømmelse)
2.0
Giolisbeth

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 Flere

$25 AUD in 3 dage
(1 bedømmelse)
1.3
makrishnaraj

Hi, My name is Krishnaraj, I am an VBA developer in an MNC company. I have worked on similar to your required project. (Form based Employee production tracker) please contact me to share my existing production tr Flere

$60 AUD in 3 dage
(3 bedømmelser)
0.8
nucleussoft2

Dear Sir, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requir Flere

$25 AUD på 1 dag
(0 bedømmelser)
0.0
mike160989

A proposal has not yet been provided

$30 AUD in 5 dage
(0 bedømmelser)
0.0
wenguo214

Thank you for your posting. I have rich experiences for VB programming with Excel, Access in several years. So, this task is very interesting for me. If you hire me, I'll complete this project as soon as possible. Flere

$30 AUD på 1 dag
(0 bedømmelser)
0.0
kellyindependent

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 Flere

$25 AUD på 1 dag
(0 bedømmelser)
0.0
Akhil12z

A proposal has not yet been provided

$25 AUD på 1 dag
(0 bedømmelser)
0.0
burgawy

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 transl Flere

$30 AUD in 3 dage
(0 bedømmelser)
0.0
anamuntean1993

Hey! 3 years working with Microsoft Office , also hold a certificate attesting that [login to view URL] you have other willing , but I can assure you they are the best option when choosing a committed !

$20 AUD på 1 dag
(0 bedømmelser)
0.0
arsa89

A proposal has not yet been provided

$25 AUD på 1 dag
(0 bedømmelser)
0.0