Encerrado

Develop a proof of concept for me in Access (or you can use a different system if you prefer)

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.

Habilidades: .NET, Excel, Microsoft Access, SQL

Ver mais: proof of concept, in process access, excel convert access, develop tool, project 2013 access, concept paper sample, convert access access 2013, convert access 2013, use sharepoint 2010 front end access 2010 database, proof concept net, net concept, cards net, can convert project, someone develop access database, access tool, Excel develop, sample concept, system concept, convert project excel access, convert excel project access, access cards, proof concept, convert excel net, cards excel, develop access databse

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #5146100

26 freelancers estão ofertando em média $602 para este trabalho

ITservice

Hi, I have 5+ years of experience. Developed various projects in .Net with MsSql database. Infact, 90% of the projects done so far are in ASP, which includes simple dynamic page to complex ecommerce related websites. Mais

$721 USD in 15 dias
(97 Comentários)
7.1
torajiv

I propose to build you this project in MS Access - I can work with either 2007 or 2010 and if required even with version 2003. You have provided a very clear outline about the project specs - however in order to take Mais

$400 USD in 10 dias
(160 Comentários)
6.8
proteamspb

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 Mais

$600 USD in 10 dias
(17 Comentários)
6.2
wsh2

Greetings from Easton PA.. {smile} Highly experienced (24+ years) MsAccess, MsExcel, Visual Basic, and Windows programming and database expert with Guru / Mentor level technical credentials at www.experts-exchange.c Mais

$631 USD in 3 dias
(37 Comentários)
6.2
winnet21

Hi, I am very interested your project please refer programs that I done here: [url removed, login to view] I happily if work with you in this project. Best Regards Duc

$600 USD in 20 dias
(30 Comentários)
5.7
CrySoft

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

$888 USD in 20 dias
(3 Comentários)
4.5
murtaza1981

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 Mais

$700 USD in 15 dias
(7 Comentários)
4.2
sunshinelabs

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 Mais

$780 USD in 3 dias
(7 Comentários)
4.1
Pharoa

I have read your tender advert and understand your requirements. Based on this actuality, I hereby submit my bid to develop the proof of Concept application using Ms Access 2007 and Ms Exce2007. My experience covers Mais

$500 USD in 10 dias
(1 Comentário)
3.8
pnjadhav

I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(A Mais

$777 USD in 15 dias
(3 Comentários)
3.3
ziafar

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

$450 USD in 10 dias
(4 Comentários)
3.6
TrackProgramming

A proposal has not yet been provided

$567 USD in 12 dias
(1 Comentário)
1.9
sken

Hi avsellerus1! Im Rick and i believe im able to complete this project for you within 4 days and another day for testing (total of 5 days). I could probably get it done earlier, but I'd like to allow for some time i Mais

$555 USD in 5 dias
(1 Comentário)
1.8
bgriffin001

I have already written payroll systems in access that included time & materials. This will make the process go much faster and less trial-and-error. My last one was for a MLM company here in Clearwater,Florida. View Mais

$666 USD in 5 dias
(1 Comentário)
1.0
osandau

This sounds like quite a fun little project. I'd very much like to do it, as I have done similar things previously. Will definitely use Access, as it's nice and easy to work with forms and make a user friendly frontend Mais

$400 USD in 7 dias
(0 Comentários)
0.0
parttimecoder

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.

$555 USD in 5 dias
(0 Comentários)
0.0
rapidDev2010

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. Mais

$444 USD in 5 dias
(0 Comentários)
0.0
mobileexp

Hello, Thanks for your post. We have reviewed your requirement and based on it we have created the document which contain our understanding and the queries regarding the requirement, please find the dropbox link Mais

$736 USD in 15 dias
(0 Comentários)
0.0
freedevs

Hey There ! I want to deliver this project to you. I am confident to deliver quality output. Please pm, for further questions you might have. I suggest SQL Express and C#...reasons are many. We can discuss on this Mais

$722 USD in 3 dias
(0 Comentários)
0.0
AccessDatabases

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 Mais

$555 USD in 3 dias
(0 Comentários)
2.8