MS Access Data Clean Up/ De dup - Need soon

We have several MS Access tables which need to be combined and de duplicated.

Separate into Tables

• Each record will have a category, membership and license type. These will need to be split up into many to many tables

Formatting clean-up

• All phone, fax as numbers with phone formatting

• Any company names in all CAP should be Title Case but do not lose acronyms spelled all in CAPs

• Convert all web address to having http://www. Versus some have www.

• Check for poor formed email, phone, fax

• Put Zips in same column (Canadian and US are in separate columns at times

• Remove all &

• Those without categories check on line to clean up

Data Clean Up

• When de duplicating there are some records in some table with complete info and others without. I need to have the most complete info for each record

• A few records will need to be hand verified - If Websites don’t match verify online, If Phone’s don’t match verify online

• In total there are about 300-400K records in about 15 tables. Many of the fields are the named the same already. Some will need to be changed.

Skills: Data Entry, Data Processing, Perl, PHP, Research

See more: verified email data, up as, ms access with php, ms access online, formatting websites, c versus c++, email clean up, check data, canadian numbers, data online, cgi company, UP, the de, poor, ms s, ms access, ms access to web, ms access email, email clean, Data tables

About the Employer:
( 40 reviews ) Moraga, United States

Project ID: #147381

4 freelancers are bidding on average $52 for this job


please check PMB

$80 USD in 3 days
(98 Reviews)

Hi, Expert in MS-Access, see my PM. Thank you.

$50 USD in 2 days
(49 Reviews)

I am a professional dB expert. Please see my PM.

$49 USD in 2 days
(0 Reviews)

Please visit [login to view URL]~ellacook/[login to view URL] At ERC Data Management we believe that database design is an art and a science. It requires both immense creativity and proven development e More

$30 USD in 1 day
(0 Reviews)