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.

Compétences : Saisie de Données, Traitement de Données, Perl, PHP, Recherche

en voir plus : 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

Concernant l'employeur :
( 40 commentaires ) Moraga, United States

Nº du projet : #147381

4 freelance font une offre moyenne de $52 pour ce travail


please check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(98 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(49 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)