Cancelado

MS Access Data Clean Up/ De dup - Need very 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.

Habilidades: Processamento de Dados, Processamento de dados, Perl, PHP, Pesquisa

Ver mais: verified email data, up as, formatting websites, check data, canadian numbers, cgi company, up, the de, poor, ms s, ms access, email clean, data tables, data formatting, data convert, clean, clean up, clean email, cap, c de, c access, access web, php data table, access clean data, named

Acerca do Empregador:
( 40 comentários ) Moraga, United States

ID do Projeto: #147883

38 freelancers estão ofertando em média $63 para este trabalho

ghumber

Hi, I am available to work on your project. Please do not hesitate to contact me

$50 USD in 2 dias
(103 Comentários)
5.9
teamspirit01

I can do the first and second part for you. I already have the data you sent me earlier. Thanks!

$100 USD in 2 dias
(19 Comentários)
4.8
asaikiran1979

Will complete formatting right away.

$30 USD in 0 dias
(49 Comentários)
5.0
c4p

Hello, I have rich expirience in this field. Please contact me form more information.

$100 USD in 5 dias
(2 Comentários)
4.4
mahecbe

Ready to start. Please check PM. thanks.

$100 USD in 7 dias
(4 Comentários)
3.1
elmoe01

I can work on it immediately sir. Looking forward to working with you. Thank you.

$70 USD in 15 dias
(14 Comentários)
2.5
Moveoffshore

Dear Partner, We are American expatriates and we offer a wide range of data entry services, web research and database management. We could definitely help you with your project. The bid we have done may change Mais

$60 USD in 5 dias
(1 Comentário)
2.0
venkinath

Hi, Please look into the PMB for details. Regards, Venkatesh.R

$60 USD in 3 dias
(2 Comentários)
2.0
dataspaceca

I have very good experience in access. I can start the project right now.

$50 USD in 3 dias
(3 Comentários)
2.2
purcino

Hi I can do this job for you. I'm experienced in database management. I'm ready to start.

$40 USD em 1 dia
(2 Comentários)
1.7
datasoltech

please check PMB for details

$30 USD em 1 dia
(1 Comentário)
1.4
waterenglish1

Hi, Please check PMB for details. Regards, Water.

$75 USD in 5 dias
(2 Comentários)
1.2
syneit

Hi…Thank you for providing a chance to bid by posting the project. My expertise are very much inline with you requirements. I have already worked on this kind of tasks. For further details please see PMB….Thanks (Shahi Mais

$100 USD in 3 dias
(1 Comentário)
1.8
geosterya

I am expert in VBA for MS Access. I own typewriting also. I can start immidiately

$100 USD in 10 dias
(0 Comentários)
0.0
mjfportland3

I'm a database marketing professional with over 10 years experience in MS Access. While the project seems as though it could take less time, it is hard to estimate how much information will need to be manually researc Mais

$60 USD in 4 dias
(0 Comentários)
0.0
esicinc

Hi, My recent Access Projects were 1. Development of Database to implement SMS Technology. 2. Development of Contact Management Database for Real Estate Business 3. Database for Red Cross Society of Minnesota, US Mais

$50 USD in 3 dias
(0 Comentários)
0.0
webwerksgirl

I'm a stay at home mom ad can have this done in no time.

$50 USD in 7 dias
(0 Comentários)
0.0
cgcentral

Good afternoon: I am a freelance Database Developer and Creative Writer, and a former Report Specialist and Database Adminstrator for SQL Server and Oracle with the Eckerd Corporation. I have a great deal of experience Mais

$100 USD in 2 dias
(0 Comentários)
0.0
think

Your project demands a good experience in data management and database design. I can offer both skills to produce the right result. We will have to re-discuss the bid to accomplish all three parts.

$100 USD in 5 dias
(0 Comentários)
0.0
Sabrina040

Thanks for the project and Please check PM.

$80 USD in 2 dias
(0 Comentários)
0.0