Find Jobs
Hire Freelancers

Web Based Data Entry

$30-250 USD

已取消
已发布超过 11 年前

$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: 4031751

关于此项目

2提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
2威客以平均价$575 USD来参与此工作竞价
用户头像
we can do this for you.
$250 USD 在20天之内
4.9 (68条评论)
5.2
5.2
用户头像
we carefully read your requirements & understand your needs it can be done in time smoothly with full satisfaction please check our portfolio in pmb
$900 USD 在21天之内
4.3 (20条评论)
4.6
4.6

关于客户

INDIA的国旗
Coimbatore, India
0.0
0
付款方式已验证
会员自11月 16, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。