Phase 2 of Access Program for Employee Performance Tracking.
Currently the program allows an admin to add employees, projects, tasks and products. In turn the Admin can then assign tasks to employees. Employee logins and can only see tasks assigned to them. They select task, start the task from a drop down and then can enter number of items made and number of items wasted throughout the day. They can also suspend and complete the task. The admin can generate a graph that shows items made, waste, percentage completed, etc.
After implementing this on the floor we found changes and additions that need to be added that include the following. Keep in mind that the changes and additions might require additional changes to existing tables, etc. The items listed below exist on several forms and will need to be changed throughout.. "Change this > to this"
Project > Job #
Task Name > Activity
Product > Part #
Completion > RPH (Rate Per Hour.) Average Parts Per Hour based on current parts and current hours.
Waste > Estimated Time (will be an estimate time to complete. For example 24 hours)
Target Quantity >Order Quantity (Quantity ordered by client)
Need to add....
Expected Quantity (Quantity we expect to produce)
Suspension Reason ( Need "Add Suspension Reason" in Admin Control Panel. Admin adds a "reason" . Admin needs option to set that reason to stop the work clock or continue it. Can be a tick mark or other means. Only selectable on Admin Panel.)
The program will needs to track the hours worked for a task. So when they "start" a task and "complete" a task the total hours need to be recorded. Tasks may take 4 hour or 40 hours. There is no definite set time for any task. For that reason, if a tasks is suspended for end of workday the time must stop until it started again. The suspend option is located in the status drop down. When the employee clicks suspend there needs to be a popup or other means for them to choose a reason for the suspension. The reasons in this list are created by the Admin in the "Suspension Reason" option in Admin control panel. The reason will either stop the work clock or not based on how the Admin set it up.
The Rate Per Hour mentioned earlier will need to take into account how many bolts were made on average for the time worked. For example an employee starts a task and completes in the same day. He started it at 8am, ended it at 4pm. During that time he took a 1 hour lunch and took 1 hour for setup. The lunch option stopped the clock. The setup does not stop the clock. That's 7 hours of logged time and you would use the amount of bolts made to get the average for that 7 hours.
The current phase of this project has a chart option. This needs to be modified. Items to be included and selectable by the admin as part of the chart.. # parts made, rate per our, total time. At any time the admin should be able to select employee(s) and view their current total rate per hour, not just for a task but a standing total rate per hour. In turn it needs to have the option to select a month, a day, a year and a selectable date range.
In this project you need to take into account that the modifications requested could break or change something in a way that is not desirable. That possibility needs to be taken into account as part of the project and not as additional task.
If you have suggestions for a better approach to this project that would make it easier, for example something other than just access... SQL + Access ? Please speak up. Currently we only see the need for one employee to be logged in at a time. Not even sure if multiple logins are supported in the current state. Would like to see what needs to be done to allow multiple logins if that becomes an issue.
Time frame for completion is not a huge concern. Would like to see about 7 day turn around but if it goes over we are not that concerned. Usually available 8a to 5p pacific here on site.
I have added the first phase of this project completed by a freelancer. He fulfilled all criteria and once we tested it on the floor decided it needed more tweaking and function. Please view this file and determine if you can use this as a base to work from and adjust your bid if appropriate. I have already adjusted some of the field names I mentioned for this project.
10 freelance font une offre moyenne de $188 pour ce travail
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. I will focus on user friendly interface. As you can see I have very good rate, you can b Plus
Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I have gone through the complete description a Plus
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer and also I'm a mathematician from Georgia, with a strong background developing a wide range of accounting, economical, Plus
I will help quickly and efficiently. The first result within 24 hours! Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, famili Plus
I will make desired changes in the database to the best of my ability. Will also try to make it a bit more intuitive to use for the employee, as currently I think the Task Status setting is a bit awkward. One thing Plus
I have reviewed description and I can develop this phase 2nd of employee tracking software --------------------- I have total 10 years of industry experience and 8 in years in (Asp.net,Asp.net MVC,C#, Entity framew Plus
Dear Employer Multi-user login system can be designed in MS Access. if you have a medium size business then Ms Access and SQL is fine . I have gone through your new requirements to be added in the existing syst Plus
I have already done pretty much exactly this for Cotton restoration construction in Houston some years ago. They had an all Excel sheet T&M accounting system which I converted to Access. The employee time sheets as wel Plus
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription. Good luck and succeed in this project.
Hello! I can help in this project! I have the 16 years of experience in the field of automation of the financial sector and trading companies. I am an expert in the field of databases: MS Access; SQL Server 2000-20 Plus
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. I have done something similar to this. If interested in hiring me then please let me know so tha Plus
I can meet your requirements and also easily show you how to make this app a multi-user app. Nothing you are requesting is unusual or difficult to implement for an Access designer and I don't foresee any reason to not Plus