已取消

MS Access to MySQL online

We have an existing Access Database that's loosing information. We found out that the design of the database was poorly done and therefore the loosing of the data. The database was split into the back-end (saved in one of the two computers in the office) and the front-end for the two users we have in the office.

Now we want to create a similar database in MySQL so we can run it from our new [url removed, login to view] account and have a user interface (the front-end) on our website (in a private page) so we can have access from anywhere in the web (eventually we would like to have an android app so my family can access it from their phones).

My family's business is Insurance Sales, all types and from all companies.

The database keeps records of our customers and their insurance packages. We also keep in record the multiple Insurance companies we work for and their contacts. Having this in mind, The database needs to have a many-to-many relationship, since one client can have multiple policies from the same company, and one company can have multiple clients in one policy.

In a policy there is usually three people involved: the person how buys the insurance (the client), the person that the insurance is for (the insured), and the person that will receive the benefits (the beneficiary). All three people can be the same person, but they could ALSO be different people.

First example: for a car insurance policy all three people can be the same person. the client buys coverage for his own car, he is the one who's covered, and hi is the beneficiary in case of repairs.

Second Example: A husband (the client) buys a life insurance for his wife (the insured), in which the beneficiaries are their kids.

In regards of the database design, I will send the tables we've used on the Access database and they can be reorganized as needed. The tables names are in Spanish but I will translate them into English for your reference, but we want keep the Field names in Spanish. Same with the front-end, I will help you to use the proper words in Spanish.

As for the front end, it needs to be an online user interface, with login and password. It doesn't need to have a direct connection with our website, since this is for internal use (instead we'll use a subdomain). The programmer has to be able to recreate the existing queries in the MS access database, design a simple but organized user interface. The new interface does not needs to look the same way as the MS Access database, but it needs to have the same ways to obtain the information.

Since I will upload the old database, the programmer will have a good idea of what we were trying to achieve. We would like to have a design proposal from the programmer before any work is performed, in order so see if the concept is clear. Time frame, approaches, methods and languages are some of the information we need to know upfront.

Please review the database (and its Spanish Version for reference) and prepare a list of questions for me.

技能: Javascript, 微软Access, MySQL, PHP, 用户接口 / IA

查看更多: work husband, work for online companies, who to use as a reference, who can help me with php online, which languages we can use for create a website, what's online business, what i need to have a programmer mind, what does a programmer need to know, what a person needs to create a web page, want to create my own database, user interface companies, used car sales people needed, used android phones, types of web design languages, types of online business, translate work online, translate who in spanish, translate was in spanish, translate english to spanish online, translate app needed

关于此雇主:
( 2个评论 ) concord, United States

项目ID: #5055061

21 威客就此工作平均出价 $367

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. 更多

$1666 USD 在10天内
(936条评论)
8.5
ielkfarna

Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,

$315 USD 在14天内
(45条评论)
6.6
envisionops

Greetings from Envision! We are a group of experienced Programmers. we have coded more than 150 websites and cms in past 1.5 year. We will convert your existing database to sql within a week. Please have a look at ou 更多

$210 USD 在7天内
(89条评论)
6.1
winnet21

Hi, I am very interested your project, I happily if work with you in this project. Best Regards winnet21

$833 USD 在25天内
(44条评论)
6.1
ramyrafik

Hello, I'm an experienced C# developer. I have experience designing Database models. I have downloaded the Access Database and I have many questions. Please contact me in Private Message. What language do you want the 更多

$150 USD 在7天内
(8条评论)
4.6
mrintelligence

Hi I have developed this kind of Business Applications in the past. Please take a look at below 2 (two) demo, in that we have all requirements fulfilled. You can access this application through Tablets/Smartphone 更多

$222 USD 在11天内
(19条评论)
4.7
elboukharimu

Hi, I'm very interested helping you converting your Access database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is som 更多

$250 USD 在10天内
(32条评论)
5.3
IslamMinhajul

Hi I am working on MS-Access and mySQl from 17 years and can solve your problem. also I have done similar job before

$277 USD 在8天内
(15条评论)
4.7
nikhiltechnology

Hello I can migrate your database form Access to MySQL perfectly and will also tweak for the better performance I am bidding for the database conversion regards Nikhil

$144 USD 在10天内
(25条评论)
4.3
tCognition

Hi, Have a great Development experience on the project in Mysql and PHP, Can develop anything your work looks interesting and can make it better. A warm welcome to you, My name is Allwyn Silva and I represent 更多

$263 USD 在30天内
(7条评论)
4.5
crushred

I am a professional software engineer with over 28 years experience in PHP(10 years),javascript(15 yeasr) Jquery(3 years), HTML(15 years), CSS(15 years), MYSql(10 years), MSSQl(17 years) and Oracle(17 years). I can cre 更多

$555 USD 在12天内
(3条评论)
4.1
deadbrains

Hi there, We have checked all your details and we are sure that we can do this project as per your requirement. Let me know if you need any more details Thanks & Regards, Team DeadBrain

$222 USD 在5天内
(5条评论)
3.7
DevelopersTeam85

Hello sir,  I have seen your requirement of the project and can do the mentioned requirement with good efforts and 100% completion with good quality and on time completion. Website Implementation Done :  ------- 更多

$204 USD 在19天内
(6条评论)
3.6
ziafar

hello i am expert in ms access i can help you. at your disposal if you need more informations. Regards

$526 USD 在15天内
(2条评论)
3.2
ShadowMaster971

Hello, I can do the job for you. i use MySQL Databases every day and design them is easy for me. I'll show you the entire process of design and creation, and i'll work close to you so you could ask all the questions 更多

$222 USD 在7天内
(3条评论)
2.2
amrodev

we can do it some of our work : [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] 更多

$155 USD 在3天内
(0条评论)
0.0
mrsh3757

I have 15 years of full time IT experience and during my tenure I have designed and developed insurance solutions for big Insurance companies. I have worked on bringing together/consolidating their disparate policy, c 更多

$155 USD 在3天内
(0条评论)
0.0
JonathanAnsa

Hi, My name is Jonathan Sanchez, I am Computer Management Enginier, I have about 3 years as a freelancer, and 9 years performing the analysis, development and implementation of all types of projects, namely: desktop a 更多

$444 USD 在7天内
(0条评论)
0.0
rovinence

I've designed databases in SQL Server, MySQL, and MS Access and have close to 10+ years experience. I also have about 8 years with UI design, including javascript, html. I would love the opportunity to make your busine 更多

$472 USD 在7天内
(0条评论)
0.0
ameenulhaseeb

Dear Sir, I Read your Requirement and Understand Everything. i will Provide 100% Satisfaction Guaranty to you. Give me Chance to Work with you. Currently i am working as web developer in kerala.I have experience in 更多

$155 USD 在3天内
(0条评论)
0.0