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.

Skills: Javascript, Microsoft Access, MySQL, PHP, User Interface / IA

See more: 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, the proposal online, spanish work online, sales with company car, programmer help online, php mysql online help

About the Employer:
( 2 reviews ) concord, United States

Project ID: #5055061

24 freelancers are bidding on average $346 for this job


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. More

$1666 USD in 10 days
(505 Reviews)

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 in 14 days
(31 Reviews)

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

$833 USD in 25 days
(30 Reviews)

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 More

$210 USD in 7 days
(63 Reviews)

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 More

$263 USD in 30 days
(7 Reviews)

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 More

$250 USD in 10 days
(14 Reviews)

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 More

$222 USD in 11 days
(8 Reviews)

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 More

$555 USD in 12 days
(3 Reviews)

Hello / Saludos, In 5+ year of experience working with XHTML, PHP, Jquery, CSS, ASP.NET, MS SQL Server & MySql I have acquired a good set of skills that might be of help for your project. I'm a very hard-working More

$166 USD in 2 days
(5 Reviews)

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 in 8 days
(3 Reviews)

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

$526 USD in 15 days
(2 Reviews)

I have over 10 years experience in MS-Access & ready to start working. My services are fast & reliable and you can trust me to do your project.

$160 USD in 5 days
(8 Reviews)

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 :  ------- More

$204 USD in 19 days
(2 Reviews)

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 More

$150 USD in 7 days
(2 Reviews)

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 More

$222 USD in 7 days
(3 Reviews)

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 in 10 days
(2 Reviews)

Over 9 years of experience. Please, do not hesitate to contact us for demos and details. Warm regards, Yuei Nakada

$250 USD in 5 days
(2 Reviews)

we can do it some of our work : http://www.prote More

$155 USD in 3 days
(0 Reviews)

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 More

$155 USD in 3 days
(0 Reviews)

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 More

$472 USD in 7 days
(0 Reviews)