iPad Database Application

Closed

Description

This project is for the creation of a custom data entry program so employees can enter data into an iPad when visiting customers, transmit data to our office computer and generate reports. It will have 3 main components:

1. iPad app with several electronic forms and a navigation menu.

2. Data transfer program to transfer the collected data through the internet to a main database on our office computer.

3. An application/database on our office computer to conduct simple calculations, print preformatted reports and allow for simple online queries.

The hardware that we will use is as follows:

- Data Collection would be done on iPads. If tablet PC’s with Windows OS can be used in addition to iPad that would be an advantage but it’s not a requirement.

- Office computers all have Windows OS and are on a network.

Below are details of how the program should work -

iPad App:

(1) When the app is opened it should show a main navigation screen with options: (a) start work (b) end work (c) view incomplete work (d) find customer (e) find record.

(2) When the user visits a customer he selects “start work” which directs him to an electronic form (“Customer Form”) and he enters common information for the customer and the number of Main Forms to be completed at that customer. He then completes as many Main Forms as needed and then clicks “end work” when done. All Main Forms entered between “start work” and “end work” should be associated with that specific customer. Date, start and end time should be recorded.

(3) When “end work” is selected, the screen should show the target number of Main Forms, the actual number completed and the number that remain. He should then have the option to select one of the following options: (a) work complete–end work, (b) work incomplete, schedule another visit, (c) work incomplete–no further visit needed.

(4) Please see the attached file for more detailed information about iPad app.

Data Transfer

(1) Data should be transferred through the internet to the main database on the office computer when an internet connection is available. This can be automatic or manual. The data is not highly sensitive but there should be some basic encryption.

(2) Our thought was that the data be uploaded to our web hosting server and then downloaded to the office computer but we are open to better or easier ways to do this.

Office Application:

(1) Data from the iPads should be consolidated and stored in a main database on our office computer.

(2) There are 2 pre-defined print reports that should be generated by this app. The user should be prompted to enter the customer name and a few other data items (address, contact name, etc.) that will be used to generate the report.

(3) The calculations for the report are simple addition / subtraction from the collected data and from some defined variables (about 15 variables). There should be a way for the user/admin to periodically adjust the values of the variables if needed.

(4) Parts of the print reports are fixed, but the text should be editable before printing so that the user can change, add or deleted words or sentences.

(5) See the attached file for more info about the report and calculations.

(6) There will be 4 basic on-screen reports: (a) list of customers visited during a selected time period, (b) list of customers visited by employee (c) list of incomplete visits (d) customer overview

(7) There should be a way to export data to Excel/Access.

(8) There should be a simple way to backup the main database.

The app should be simple to use. If your approach requires specific hardware or software, please indicate in a PM. If you need more detailed information, diagrams, flow chart, sample screens or sample reports please let us know.

If you have any questions, please ask before bidding.

Skills: C# Programming, iPad, Microsoft Access, MySQL, Visual Basic

See more: ipad database app, access app ipad, access ipad app, ipad database, ipad access app, access ipad, program access database ipad app, ipad database access, work access ipad, ipad database application, database ipad, ipad data collection, visual work flow, visual basic online programming, visual basic 6.0 online, visual basic 5 online, variables in programming, user diagrams, use diagrams, transfer flow parts, target employee, stored program computer, simple words computer programming, simple file database, simple computer programming

Project ID: #959763

20 freelancers are bidding on average $2090 for this job

rickbdotcom

Hi this sounds like an interesting.

$2500 USD in 30 days
(23 Reviews)
7.5
MAnkita

Hello,Please refer your PMB.Thank you.

$3500 USD in 35 days
(59 Reviews)
7.2
hasanakhtarkhan

Please view your private message.

$1100 USD in 30 days
(3 Reviews)
5.5
fusioninformatic

Hi Good Morning, Hope you are well. We have review your proposal and we found that we can fit into your requirement. We have very strong expertise in building small to large scale web application. So far we h More

$1450 USD in 40 days
(3 Reviews)
5.5
atchayagandhi

Hi, We are very hopeful in providing you a working solution in this regard, Kindly refer your private message board.

$1000 USD in 20 days
(5 Reviews)
5.4
DBguy

Good afternoon. I am ready to start. Please check your PMB. Thanks for the consideration. Best Regards.

$1200 USD in 14 days
(18 Reviews)
4.7
ranganathp

Can help... I am an expert... please check my reviews, qualifications and latest projects i have worked on... please provide more details so that i can give you an accurate bid...

$5800 USD in 45 days
(6 Reviews)
4.2
anjeko

Hello Please read my PM Regards Jerry

$1150 USD in 10 days
(1 Review)
3.9
mastersoft1

i'm experieced C# programmer I can help you

$1500 USD in 15 days
(9 Reviews)
3.5
BSoftTech

Hi, I've extensive experience in c#, Visual basic and MS Access with tablet PC programming. Please see private message for more details Thanks, John

$1500 USD in 40 days
(2 Reviews)
3.2
vishal68Flancer

i am a .net professional developed many projects in asp.net vb.net c#.net sql, oracle and created various type of crystal reports.

$1500 USD in 24 days
(0 Reviews)
0.0
Debonair2010

Hi, I am doing similar activities from the past 2 years. I can complete this work as your timelines and project cost is neogitable as per you. please provide me more details so that i can help u in this regard. Wi More

$1200 USD in 30 days
(0 Reviews)
0.0
ybetzer

I am an experienced iPad, iPhone, Flex and C# developer. I find your project interesting and would like to get the chance to build it. Best regards, Yonatan Betzer

$1500 USD in 30 days
(0 Reviews)
0.0
ZhiZhang

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f More

$1500 USD in 15 days
(0 Reviews)
0.0
globaldesk

Please check PMB

$2200 USD in 35 days
(0 Reviews)
0.0
RedRockSolid

Please check my PM.

$2000 USD in 30 days
(0 Reviews)
0.0
expertcyber

Hello, Please check PMB for details. Regards EC

$2200 USD in 45 days
(0 Reviews)
4.3
mahmoudtn

Hello, Please check PMB. Thank you.

$6000 USD in 53 days
(0 Reviews)
0.0
simaann

Please see PMB

$1500 USD in 7 days
(0 Reviews)
0.0
hantana

Please check the PM

$1500 USD in 30 days
(0 Reviews)
0.0