database build / data refine
box top
 
Project Details
Project Category : Admin/Secretarial > Database Management

Project ID : 4539

Project Title : database build / data refine

Project Location : Remote

Project Status :
Bid Accepted
Project Description
Hi,

I run a small telemarketing agency and I now need to organise all the data I've collected from various sources.

In all there are about 15 excel spreadsheets with varying information on each spreadsheet. There are also duplicate records on each spreadsheets and within all the data as a whole. total records across all the spreadsheets probably number 10000 or thereabous (some of the records have multiple contact names for the same company).

I need a simple access database designed whereby I can import all the records with all the data fields, de-dupe the records then be able to pull off chunks of data dependent on searches in various fields eg county, size of company, industry etc. Not all the spreadsheets have the same information on so it will take some organising to actually get the fields in place. I also need an 'idiots guide' instructions on how to import further data/ export data after running a report and how to actually do the searches.

oh and I need this completed asap:) any clarification needed just ask.

cath
Project Budget
Project Type : Fixed Price Project

Budget Range : Prefer not to disclose

Budget Type :
Fixed Fee
Additional Information
Approx Start Date after bid is selected : Immediate (within 1-2 days)

Attached files : None
Buyer: cath R
cath R Buyer History
Posted : 9
Bidding Details
# of bids :7
Bidding ends :Project expired
Project posted :
21/10/2008 01:04 pm

 

box top
box top
Accepted Bid

Bidding is currently closed for this Project as the Buyer has accepted the bid below.

The Buyer can still choose to reopen the bidding prior to the project listing end date.

Details of the accepted bid

Amount: £ 125.00 Fixed Fee

Proposal:
Dear Cath,
I am a Freelancer and have worked as a programmer for different companies. I have extensive experience in working in Microsoft Access and have created several applications / databases using Access.

I am interested in this project and with all the details available, I can complete this project in 3 days.
I look forward to receiving your response for my bid and work with you.

Thank you,
Regards,
Anandhi

Estimated Start Date: Within 1 Business Day

box top
box top
Providers who viewed this project also viewed
Urgent Flash Coding Work - £600 Budget - work required ASAP (3days - 1week)
Expires: 5d, 23h | #Bids: 5
Telesales
Expires: 7d, 3h | #Bids: 14
Advertising Sales poss shareholding
Expires: 22d, 6m | #Bids: 7
THE NEXT BIG THING IN VIDEO - web design project
Expires: 5d, 7h | #Bids: 10
E-commerce Site Asp.net or PHP
Expires: 6d, 1h | #Bids: 21
box top
box top
Clarification Board
Providers can use the Clarification Board to ask the Buyer any questions prior to placing a bid. The Buyer can use the Clarification Board to provide clarifications about the project.
To post a message/question you will need to be logged in as either a Provider or the Buyer that has posted this project.
box top
Post New Message

*
 
The Clarification Board should only be used to ask questions about the project if further information is required before placing a bid.
Any messages including contact details (email/phone), company names or messages such as "I can do this" or "Please contact me" are liable to be reported by other users and deleted.
box top
 

cath R
  By Buyer (cath r) on 22/10/2008 07:59 am Report This Message
hi melanie,

i need the data imported and deduped in the first instance and instructions on how i do it in the future. looking to get this sorted asap.

regards

cath
 
 
     
box top

MELANIE P
  By MELANIE on 21/10/2008 04:32 pm Report This Message
Could you please clarify whether: you want the database designed and delivered as an empty structure ready for you to import these spreadsheets and work on the data youself, OR, whether you want to receive the database with spreadsheets already imported, with fields standardised as far as possible, and deduplication already done?

I would be very happy to undertake this for you, and have had wide experience of importing different types of file to new Access databases for further processing, and in writing 'idiot guides'! Could make immediate start.
 
     
box top
box top

Joshua S
  By Joshua on 21/10/2008 04:17 pm Report This Message
Hello Cath,

This sound very interesting and straightforward. I should be able to 3 days max.

Josh
 
     
box top
box top

© 2007-2009 People per Hour. Use of this Web site constitutes acceptance of the People per Hour Terms of Business, Web site Terms of Use and Privacy Statement