Closed

Build a database / create / design / add rules for processing / export

I'm not sure the best way to do this. I believe it is through a database.

i have raw data that has a list of Owners and the Properties they own.

I want to be able to mail one letter per owner.

This requires :

1. Separating the owners into Businesses and People

2. Formatting the Businesses and People's name into a clean format

3. Produce 4 lists

a. To Be Mailed

i. People (Duplicates Removed and Names cleaned/standardized)

ii. Businesses (Duplicates Removed and Names cleaned/standardized)

b. To Be uploaded into Podio

i People (Duplicates included and Names cleaned/standardized)

ii. Businesses (Duplicates included and Names cleaned/standardized)

The four list would be outputed into csv, google sheets.

Please provide guidelines of how you would do this at a high level.

Also, please provide an estimate of how many hours this would take.

I attached a copy of the raw data, that i want to upload into the database, have exported into clean data into the second tab format.

To ensure that I know you read the post fully, please type (Odinson) at the beginning of your reply. :)

Skills: Data Entry, Database Programming, Excel, Microsoft Access, PHP

See more: common errors in database design, database design, database development process steps, microsoft access, sql, when designing a database, why is it not preferable to store all data in one single table?, database design when to split tables, database design tutorial, create paypal add cart button quantity, create design site myspace, database management design job, database forms design, lotus design add field, create design, build database creloaded, design shirt image processing, create design greeting card companies, find artist create design, php create pdf add jpg, access database create table

About the Employer:
( 3 reviews ) Aldie, United States

Project ID: #18645667

32 freelancers are bidding on average $494 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. Please check my portfolio and reviews from other customers https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web More

$555 USD in 10 days
(226 Reviews)
8.6
schoudhary1553

Odinson I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without chan More

$500 USD in 8 days
(324 Reviews)
7.8
fattahaabdul

Expert in making database. Let us discuss and move ahead. I am ready to start. Please reply so that we can move ahead.

$2222 USD in 10 days
(96 Reviews)
7.8
branislavm

Odinson Hello! I think this is a good idea to go with the database for this and, specifically, with Microsoft Access for few reasons: it can handle such data very well, it has Outlook integration through the obje More

$488 USD in 10 days
(286 Reviews)
7.4
paris2785

Odinson Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an application in Excel. I plan to use VBA code to accomplish this. The More

$500 USD in 7 days
(219 Reviews)
7.2
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agree More

$538 USD in 5 days
(119 Reviews)
7.2
zeke

Odinson. Dear Customer! I am an expert PHP developer with over 15 years of experience and very interested to work on your project. Ready to begin immediately and complete as soon as possible. Please contact to discuss More

$500 USD in 10 days
(178 Reviews)
7.4
dgled

I did some projects which extract and clean up double details including names, similar address emails and more. Also, I have the knowledge to send emails from lists in Microsoft Excel via Microsoft Outlook. I want to More

$750 USD in 10 days
(73 Reviews)
6.9
lavizsolutions

Odinson I will provide you a web page where you can upload excel file and can process the file. Kindly share me more details so that i can give you estimated time and cost. 1. Case Management system. htt More

$1000 USD in 10 days
(22 Reviews)
6.5
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy More

$250 USD in 6 days
(107 Reviews)
6.2
fanninson45

INTRODUCTION I can see you are interested in building database application to manage people and your business processes. I have read your attached Sample document. I can develop this database together with other s More

$400 USD in 10 days
(25 Reviews)
5.9
archanaoswal

Odinson I have excellent command on MS Access and VBA and create the database as per your requirements in 8-10 working days. In addition to creating databases from scratch, I have also completed complex projects in Ac More

$450 USD in 10 days
(91 Reviews)
5.9
ludwig333

Hi. i am a full web developer with over 5 years on freelancer.com. I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project More

$300 USD in 10 days
(30 Reviews)
5.9
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you More

$444 USD in 4 days
(126 Reviews)
6.5
marioada

Odinson Hello, Let me get right into this. We use databases to store data that we want to have direct remote access to, something that allows us to have multiple "users" that can select, insert, update and delete More

$750 USD in 10 days
(1 Review)
5.4
Grisha97924

Odinson Hello This is Iskhakova. Developer I have just checked project details. I have completed project similar to this one. I have rich experience with Data Entry, Database Programming, Excel, Microsoft Access More

$500 USD in 10 days
(23 Reviews)
5.2
Baibsma

HI SIR I AM MAINTAIN YOUR DATA LIST AS YOU NEEDED IN EXCEL SHEET AND WORK FOR YOU ON THE TIME WE DISCUSS MORE WITH SAMPLE THANKS Odinson

$750 USD in 10 days
(16 Reviews)
5.3
aadips

Hi sir, i understand you need Build a database / create / design / add rules for processing / export for your project. i am sharing my few projects with you, please go through... sharing few projects done so far by More

$250 USD in 10 days
(47 Reviews)
5.0
kiranrajkumari

Odinson Hi I am able to make Wordpress website where you can import all your data and apply rules on them. I am 5+ years experienced web developer and sure able to do this. can you please chat with me so we can More

$500 USD in 12 days
(18 Reviews)
4.9
smileitsolu

(Odinson) Dear Sir we read your task and we can deliver it with quality. please award us project so we can start working on this Best Regards! Veer Singh

$333 USD in 2 days
(31 Reviews)
4.7