Database build / data refine
5667
$$
- Posted:
- Proposals: 5
- Remote
- #4539
- Archived
Description
Experience Level: Intermediate
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
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
Cath R.
0% (0)Projects Completed
5
Freelancers worked with
6
Projects awarded
50%
Last project
1 Jul 2009
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies