Cancelado

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.

Habilidades: Javascript, Microsoft Access, MySQL, PHP, Interfaz de usuario / AI

Ver más: 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

Información del empleador:
( 2 comentarios ) concord, United States

Nº del proyecto: #5055061

21 freelancers están ofertando el promedio de $367 para este trabajo

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. Más

$1666 USD en 10 días
(936 comentarios)
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 en 14 días
(45 comentarios)
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 Más

$210 USD en 7 días
(89 comentarios)
6.1
winnet21

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

$833 USD en 25 días
(44 comentarios)
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 Más

$150 USD en 7 días
(8 comentarios)
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 Más

$222 USD en 11 días
(19 comentarios)
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 Más

$250 USD en 10 días
(32 comentarios)
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 en 8 días
(15 comentarios)
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 en 10 días
(25 comentarios)
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 Más

$263 USD en 30 días
(7 comentarios)
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 Más

$555 USD en 12 días
(3 comentarios)
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 en 5 días
(5 comentarios)
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 :  ------- Más

$204 USD en 19 días
(6 comentarios)
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 en 15 días
(2 comentarios)
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 Más

$222 USD en 7 días
(3 comentarios)
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] Más

$155 USD en 3 días
(0 comentarios)
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 Más

$155 USD en 3 días
(0 comentarios)
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 Más

$444 USD en 7 días
(0 comentarios)
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 Más

$472 USD en 7 días
(0 comentarios)
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 Más

$155 USD en 3 días
(0 comentarios)
0.0