开放

Create a functional Customer Database in Excel

The objective of this project is to create a customer database for a business that distributes construction materials. The customer database will include existing customers (see attached file, "Existing Customers_9.18.19") and potential new customers (see attached file, "Detail20191007071000"). For each customer or potential new customer, the database will include key identifying information including: Customer Name, Customer #, Existing Customer / Potential New Customer, Zip Code, Employee Count, Sales Volume, Primary SIC Code, Primary NAICS Code...potentially others. The database should be made such that it is easy to filter based on any piece of the aforementioned "key identifying information." An initial step for this project will be to map the "Existing Customers_9.18.19" file to the "Detail20191007071000" file such that there are no duplicates in the ultimate customer database and it is evident which are existing customers and which are potential new customers.

技能: Excel, 微软Access, 数据库编程, Visual Basic, 数据处理

关于此雇主:
( 0个评论 ) Houston, United States

项目ID: #21666279

65 威客就此工作平均出价 $952

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl 更多

$750 USD 在5天内
(338条评论)
8.0
Eagles90

Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in l 更多

$1125 USD 在7天内
(142条评论)
7.8
branislavm

Hello! I see you have attached CSV and Excel file, but in the project description, you mention a database. Since CSV is a plain text file and Excel is not a database program, I believe you need to have a real database 更多

$1125 USD 在7天内
(240条评论)
7.5
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will distinguish between existing and potential custome 更多

$900 USD 在5天内
(272条评论)
7.6
PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using dif 更多

$1125 USD 在20天内
(184条评论)
7.3
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your database project. Please check my profile and contact me to discuss further details. Regards.

$750 USD 在7天内
(319条评论)
7.3
fabest

*** I AM EXPERT IN MS EXCEL DATABASES *** Dear, we are Team of French + US. I propose to create your database in Access, it is much more reliable. Please give me more details about your project. I will focus on user fr 更多

$750 USD 在9天内
(90条评论)
7.3
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje 更多

$750 USD 在5天内
(232条评论)
6.9
dgled

Hi, I am financial experts and a guru in Math, Excel, and /VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database, especially with importing external files to a st 更多

$750 USD 在7天内
(85条评论)
7.1
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do make functional customer database in excel like you want Sir please ping me now for discuss more and im able to start working right now after all clear :) Th 更多

$750 USD 在7天内
(370条评论)
7.2
zekovicm

Hi there, What kind of database would you like to have :Excel, Access, SQL, noSQL? I can create whatever you would like to have ! Please feel free to contact me to discuss further details. Best regards Milja 更多

$750 USD 在8天内
(121条评论)
7.3
antoinepal

Hello, I can build the excel database you want with the functionality you want as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!

$941 USD 在5天内
(43条评论)
6.2
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfille 更多

$750 USD 在10天内
(110条评论)
6.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$1125 USD 在7天内
(109条评论)
6.3
dvcontact

Hi, Would you like to see a quick sample list of your project on creating customer database of existing and potentially new customers which can be filtered based on any of the key identifying information completed befo 更多

$750 USD 在10天内
(50条评论)
6.4
workerbee1974

Good day, My name is Donna. I have read your project description and I feel with more detail I could complete it to your vision.  I would suggest Microsoft Access based off what I read. I can do either. I am a exper 更多

$1333 USD 在15天内
(44条评论)
6.6
sithalchordia

Hi, I have read your requirement and would like to help you with this project. I have experience in Visual Basic and Microsoft access and can develop you the database, as well as design a front end application using V 更多

$750 USD 在7天内
(18条评论)
5.8
SShtv

Hi, I am interested in your project. I have a lot of practical experience in Excel. Including the development of databases and User Forms. Your task is clear to me and I am ready to execute the project. Here are scre 更多

$750 USD 在7天内
(84条评论)
6.0
zu02

Hi, there I hope all's well with you. I can code that within Ms Excel or if you'd like via Ms Access/with Excel automation. I'll detail in private chat. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all 更多

$750 USD 在7天内
(55条评论)
6.2
fuentro

Hi. I’m Rodrigo. I’ve read your project brief and I understand you’re looking for a functional customer database in Excel with possibilities of filtering the data as you see fit. The reason of my bid, is because I wou 更多

$1666 USD 在7天内
(29条评论)
6.0