Encerrado

Access simple CRM database

Hi,

I have 500 brochures from various companies which belong to various industries and each brochure may contain a different spectrum of products. I need someone to help me classify this so that it is easily accessible to my employees. My idea is to create a simple database in Access. I was heavily using Access about 10 years ago, then my career shifted and I have not used Access for a long time, but I can communicate effectively on the design and structure of the database.

What we use now is an Excel file, there are something like 20 sheet tabs in that Excel, one for each "product category" (I am sorry I cannot send it to you), and in each sheet there is just plain information on the company name, address, email, and a cell with keywords which relate to that brochure. So, when a user tries to find eg. binoculars, it will show those rows which contain that keyword, and in this way we are directed to the x company and eventually to the x brochure. The brochures are categorized, so in each sheet tab there is also a column that next to the company name, it says brochure 2.1, 2.2, 2.3 and so on. This 2.1 corresponds to a specific location of the cupboard. This Excel is working ok, but I do not find it user friendly and information is not neat and tidy. One more comment: say in cupboard location 3.1 there are say 20 brochures, you have check all of them for the one you are looking for.

Let me have your idea, for which I admit, you will not get paid. However, due to the importance of this database to me, I am willing to pay a fair amount. You do not need to be a highly skilled VBA user, but I need you to be professional, punctual, and reliable. Oh, and work with me on design as we progress, and also provide me with free updates (minor modifications may be needed during the first months of use) for one year.

I cannot include everything here, but that is the main concept. For the person I will decide to cooperate with, payment will be done in instalments, no payment for plain communication and exchange of ideas, no payment if you produce something that I do not like, but I promise that if modifications are needed I will not walk away, I will work with you giving you directions and instructions, 10% after I approve the design and the relationships, 40% when you deliver the project to me completed, and 50% in six months after completion. We will make a proper service agreement so that I know what to expect and that you also know what to except from my side.

Thank you

Habilidades: Microsoft Access

Ver mais: access crm, crm access, crm database, excel crm, simple crm, spectrum design, simple file database, service database access, microsoft excel professional, microsoft excel help 2013, microsoft career, get microsoft access free, free professional email service, design company brochure free, design brochure companies, create free brochure, company service agreement, company brochure design ideas, companies design brochures, companies brochures, brochures design companies, professional email address ideas, microsoft vba, microsoft project free, microsoft professional

Acerca do Empregador:
( 0 comentários ) United Arab Emirates

ID do Projeto: #5080483

30 freelancers estão ofertando em média $1155 para este trabalho

torajiv

I am an exclusive MS Access developer having completed over 150 such projects in the past three years. I understand that each excel sheet belongs to a product category and all the brochure names related to this catego Mais

$803 USD in 10 dias
(147 Comentários)
6.8
jawadaman

Hi, I am interested in this job and will be grateful in assisting you. If you are interested in discussing the project then please let me know. Thanks. Regards, Jawa

$750 USD in 3 dias
(63 Comentários)
5.5
winnet21

Hi, I am very interested your project, I send you a small example that I had programmed for customer you please download example here : https://hotfile.com/dl/243889748/ba45780/POS_NEW1212.zip.html you plea Mais

$1250 USD in 365 dias
(16 Comentários)
5.1
riki888vw

Hi, I can develop CRM database for your project using MSAccqee Query and tables and C#, as desktop or WEB application. Regards.

$1250 USD in 10 dias
(1 Comentário)
3.8
SajjadHussain14

Hi, All terms and conditions are accepted. I could share a working demo based on your specific needs. Design Idea : --> We could go for an interface which will display 20 icons(for each category-replacing for each s Mais

$1111 USD in 15 dias
(3 Comentários)
3.3
ziafar

assalmo alikoum (Hello) I am an expert in MS Access and VBA. I have read your project description and I quite agree with your terms. I am ready to work in a sustainable partnership to the final implementation of th Mais

$1000 USD in 30 dias
(2 Comentários)
3.2
elboukharimu

Hi, I'm very interested helping you building and creating your Access dataabse, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, t Mais

$1263 USD in 15 dias
(6 Comentários)
4.1
logu85

Hi I reviewed and understood your project requirement of CRM Database and your Details about Existing Excel file. As you described you have a system in place (excel) now you want to upgraded/enhance for better c Mais

$1300 USD in 15 dias
(1 Comentário)
1.8
udul1975

Hello, I can do this work for you. I have developed complex databases for various information needs and using that experience I am sure I can do a good job for you. Lets have a look at the available "brochures" and Mais

$1250 USD in 30 dias
(2 Comentários)
1.6
scubapro

Dear Sir, If I may suggest something: I would go for a .NET application as frontend with an Access or preferably Sqlite database as backend where multiple users are allowed. I would create different tables, but in t Mais

$800 USD in 15 dias
(1 Comentário)
1.0
freelancercorpo

Hello, Regarding your project we can offer "advanced" access database with professional forms. As you worked with acces in the past it would be easy for us to follow and create exactly what you expect. Even if we Mais

$1000 USD in 30 dias
(0 Comentários)
0.0
namats

I have good experience in Data Entry, Data Conversion, Data Processing, Data Mining, Email Search, PDF to word or Excel, Internet Research. Highly motivated person... Experts in Microsoft Tools like Excel, Access, Wo Mais

$1250 USD in 3 dias
(0 Comentários)
0.0
calcul8ors

I am a Melbourne (Australia) based VBA Developer (Access & Excel) with many years commercial experience in large FMCG companies, which gives me a lot more insight into the requirements of businesses than your average p Mais

$1666 USD in 3 dias
(0 Comentários)
0.0
Nithinmadhavan

I've enough experience in MS access to help you out.My idea on your requirement is as follows 1.There will be a Master table for Products it will contain all the products you have available now, and you can add/edit Mais

$888 USD in 7 dias
(0 Comentários)
0.0
eruditeits

Hi, Thank you very much for posting this job in Freelancer.com My Proposal: Database : MS Access Front End : Excel (Excel will connect with MS Access using Jet Engine via VBA code) Why Excel : Since all your Mais

$1500 USD in 180 dias
(0 Comentários)
0.0
IBTO

Nie złożono jeszcze oferty.

$750 USD in 30 dias
(0 Comentários)
0.0
DatabasePlus

Hi, I am new to freelancers and don't know exactly how it works (that's why I have placed the lowest possible bid); but I have a good understanding of database designing. I ensure you that you will find me a reliable p Mais

$750 USD in 20 dias
(0 Comentários)
0.0
vw8111705vw

A proposal has not yet been provided

$1250 USD in 3 dias
(0 Comentários)
0.0
arc07

Hello! I have long experience in the development of databases. Your job I liked. My last job was similar - the transfer of a full accounting and settlement of Excel to Access. I can solve your problem in any of the op Mais

$1250 USD in 3 dias
(0 Comentários)
0.0
misabg

A proposal has not yet been provided

$1222 USD in 15 dias
(0 Comentários)
0.0