Develop a proof of concept for me in Access (or you can use a different system if you prefer)
$250-750 USD
Paid on delivery
Full description is below and also attached. I've also attached sample time cards. This project is meant to be a proof of concept that we can convert from working with paper to an imaged system. My thought process was to use access, but you can feel free to use any tool and tweak my process anyway you think it works best.
project details:
Background:
I am building a process to import a digital time card into a workflow system that will allow the user to make changes to the time card. Add additional items in fields and then export the final table into excel. The real system will not be built in access, but I want to build a demo in access with some functionality as a demonstration.
Work process:
• User imports an excel sheet (you can dictate any format you would like the sheet to look like) with the time cards (it will be multiple time cards). For this demo you can import them one at a time if its easier.
• Then the user goes to a form that displays the records visually in the same layout as I have everything arranged in excel
• The user should be able to edit any field
• There should be a button to continue to the next record
• There should also be a button “apply rule to entire batch”
o If they press this button a pop up form should come up that lets them write a rule that will apply to all records. The only section this would apply to is the large table on the right part of the timecard. The pop up window should have drop downs to set conditions of the rule. I think this can be achieved by running a query that would update the records table at completion. Let me know if this is wrong and can’t be done at all though.
Example:
Field 1 is a drop down that shows the column options (ex: prd#, account, set/pay, category, Hrs/Qty,x,Rate,Amount)
Field 2 would show all values in the column selected in 1 from the records table
Field 3 is a free form entry
• When you push save rule a query will run to input value 3 In the paycode column in every record where value in column 1 is the option chosen in field 2. The user is then returned to the 1st record in the timecard screen they were in before.
• There should also be a button “red flag”
o When pressed the record will have an indication added to it that it has been red flagged in the records table
• There should also be a button “yellow flag”
o When pressed the record will have an indication added to it that it has been yellow flagged in the records table
• There should also be a button “green flag”
o When pressed the record will have an indication added to it that it has been green flagged in the records table
• When they reach the last record and press the next record button they should be taken to a pop up screen that has 4 option buttons:
o Option 1: “review red flag time cards” – if pressed they go back to a form that looks like the time card layout but the only records shown are those that have been indicated as red flagged on the records table.
o Option 2: “review yellow flag time cards” – if pressed they go back to a form that looks like the time card layout but the only records shown are those that have been indicated as yellow flagged on the records table.
o Option 3: “review green flag time cards” - if pressed they go back to a form that looks like the time card layout but the only records shown are those that have been indicated as green flagged on the records table.
o Option 4: “export records” – if pressed the system will export the records table to an excel format.
Project ID: #5146100
About the project
23 freelancers are bidding on average $593 for this job
Hi, our team has experience in development of applications by MS Access. Could you please inform us if this proof of concept application should be a console application or web application? Best regards, Kate ProTe More
Hi, we are team with strong knowledge of .NET, C# and other .NET and Web technology. Also we have more that 7 years experience of development. For better communication we are free for conversation
I am American, live in NYC, have a BS and a day job; I need extra projects this month. I would do this in .NET (vb) using ASP.NET and for the database....MSSQL 2008 R2 NOT Access. It's Access' big brother; Why do al More
Hi, An ASP.NET,c#,vb and SqlServer expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following qualities of m More
hello i am expert in MS ACCESS and i can help you. your need can be done at all though with MS ACCESS. at your disposal for more informations. regards
I've read your requirements and it's perfectly doable, There are some suggestions for you in case you want to work with me. I'll work on a .net platform, with express editions of the database, so you can freely dis More
Hello, I can do this for you in java. I have 11 yeara of experience. Thanks Risbud Software Consultancy
I was selected to be one of the two technical reviewers for the text book 'Microsoft Access 2010 Inside Out' (Microsoft Press) - if you have that book you will find my name on the Acknowledgements page. Hopefully this More
I would like to be considered for this project. I have over 11 years professional experience in Database design and development and have developed numerous tailored database systems to meet clients exact requirements. More
Hi I already have a ready made setup with me, which I developed for a local office. I can customize it and turn it around quickly to you. Let me know if you want to engage.
Hello AVSELLERUS1, I would really enjoy doing this project for you. It looks like a lot of fun and very doable. I did a project similar to this and it does take time to work through all of the little things More