Cerrado

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.

Habilidades: Excel, Microsoft Access, Programación de bases de datos, Visual Basic, Procesamiento de datos

Información del empleador:
( 0 comentarios ) Houston, United States

Nº del proyecto: #21666279

66 freelancers están ofertando el promedio de $955 para este trabajo

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 Más

$750 USD en 5 días
(338 comentarios)
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 Más

$1125 USD en 7 días
(142 comentarios)
7.8
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 Más

$900 USD en 5 días
(272 comentarios)
7.6
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 Más

$1125 USD en 7 días
(240 comentarios)
7.5
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 Más

$750 USD en 7 días
(370 comentarios)
7.2
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 Más

$1125 USD en 20 días
(184 comentarios)
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 Más

$750 USD en 9 días
(90 comentarios)
7.3
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 Más

$750 USD en 7 días
(85 comentarios)
7.1
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 Más

$750 USD en 8 días
(121 comentarios)
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 en 7 días
(319 comentarios)
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 Más

$750 USD en 5 días
(233 comentarios)
6.9
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 en 7 días
(109 comentarios)
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 Más

$750 USD en 10 días
(50 comentarios)
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 Más

$1333 USD en 15 días
(44 comentarios)
6.6
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 en 5 días
(43 comentarios)
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 Más

$750 USD en 10 días
(110 comentarios)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Más

$750 USD en 5 días
(121 comentarios)
5.9
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 Más

$750 USD en 7 días
(84 comentarios)
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 Más

$750 USD en 7 días
(55 comentarios)
6.2
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 Más

$750 USD en 7 días
(18 comentarios)
5.8