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.
14 freelancere byder i gennemsnit $149 på dette job
[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.
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.
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 !