Find Jobs
Hire Freelancers

Web Based Data Entry Form

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I need a web based data entry form developed from a Microsoft Access form for an existing mysql database. We are currently using Microsoft Access to view / edit our existing mysql database. I would like to convert one of our existing forms from MS Access to a web-based form. I can provide a copy of the MS Access database and form. You will need to be able to build the web form and model it after our MS Access form. This form already has the format we want including the main form, the sub forms, the queries, database structure, default data items, hidden data items, etc. The database currently has no web based forms so an initial setup will need to be created such as an admin page to manage users and user rights to the new form. All code and rights will be provided to me for future use and development of our site. I would require any information required so you or another developer could edit / update your work. Tables to be used in the form (actual table names are different, just listing descriptive name here): Main Tables: clients table tickets table address table contacts table vendors table accounting table equipment table Actual number & name of tables is viewable in the MS Access Database. Rough web form need: The data entry person will need to be able to do the following: Select a Client Company Name from a drop down list (which pulls from our Clients Table) Enter the Clients Ticket Number Select the repair type from a drop down list Enter the ticket location information: - Enter the address of the ticket - Enter the zip code which will then pull from our zip code table to automatically enter the city and state Select the vendor id from a drop down list linked to our vendors table Select the vendor profile (will default to vendor selected above but allow for edits from a drop down list) Select the Timeframe Type for the Ticket from a drop down list Enter the service date and have the pay period date auto entered based on our pay period table and the related service date Enter the end date of the ticket (we use this if the ticket spans multiple days) Date received (this field will default to current date but allow edits in the event data entry is behind) Enter the time we are required to start the ticket and the time we are required to finish the ticket Show a field at the end of the data entry which allows the data entry clerk to copy and paste to create calendar events and will pull information from the above fields to show: Client Company Name, Ticket Number, Timeframe Type, and Repair Type Show another field at the end of data entry that allows for copy/paste of the location information. An option button to allow more detailed data entry for advanced tickets to include: Item code Rate Amount Rate Type Fees Description End User Name Site Company Name In the background, there will be the following items: Date entered (enters actual date of data entry) Internal ticket number (auto counting field from our tickets table) Ticket status (defaults to active) Client ID (auto entered based on the client name selected by the data entry clerk)(pulled from our clients table) Followup By: default field to indicate the next person responsible for the ticket Followup Required: default to new ticket status Your bid should be a flat rate amount to develop this form to completion. I have tried to list all relative items to make your bid easier but I cannot guarantee that I have listed all fields, tables, drop-down lists, etc. I can provide a copy of our Microsoft Access database for reference and all login information for the mysql database.
Project ID: 11996488

About the project

4 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $258 USD for this job
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$147 USD in 3 days
4.9 (73 reviews)
7.0
7.0
User Avatar
Hi, I'm a professional Ms Access developer with strong background in developing and implementing databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. I have done similar assignments previously, so check my profile for details. I'm looking forward to hear from you. Regards,
$200 USD in 7 days
5.0 (7 reviews)
4.1
4.1
User Avatar
hi i have an offer to you i have a 3 man team can work on this project on the same amount i bid u can get 3 working person to handle this project.. so it will be done in a faster dates.. I f can consider my offer u will not regret it and also for future work i bring the price down for goodwill PS.... You'll getting 3 workforce in a price of one
$222 USD in 3 days
4.6 (10 reviews)
3.0
3.0

About the client

Flag of SRI LANKA
Sri Lanka
0.0
0
Member since Nov 6, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.