Find Jobs
Hire Freelancers

Web Based Data Entry Form

$30-250 USD

クローズ
投稿日: 7年以上前

$30-250 USD

完了時にお支払い
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.
プロジェクト ID: 11996488

プロジェクトについて

4個の提案
リモートプロジェクト
アクティブ 7年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に4人のフリーランサーが、平均$258 USDで入札しています
ユーザーアバター
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 3日以内
4.9 (73 レビュー)
7.0
7.0
ユーザーアバター
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 7日以内
5.0 (7 レビュー)
4.1
4.1
ユーザーアバター
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 3日以内
4.6 (10 レビュー)
3.0
3.0

クライアントについて

SRI LANKAのフラグ
Sri Lanka
0.0
0
メンバー登録日:11月 6, 2016

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。