Customer Database

終了済み 投稿 Feb 26, 2014 着払い
終了済み 着払い

I need some guidance for a small project im putting together. The goal is to have a central place where customer information is stored, templates can be added and possibly a calendar of outgoing shipments integrated as well. The database will be designed for a small logistic company. Currently we receive all requests from our website and copy and paste it into an excel sheet. Then the request is forwarded (omitting the customer info) to our 3rd party vendors to request a price. Once received (usually through email) then we mark it up and create an official quote using a company's template. The template then is attached send out to the customer. I would like to automate and enhance the process just described.

The idea is to have imported all the data from the company's email into some kind of database (maybe Access or Excel i dont know what else can be used). since we have customers which are new and regulars the information can be stored into a table to avoid manual typing. Maybe the template can be included in the database to be prefilled with the customer information. Another feature i would like to add is a calendar which marks the "booked" shipments. For example, if customer A request a price, after recieving the quote accepts the offer then pays for his shipment to go out on day X, i would like that to be marked in the calendar.

Im not sure if it can be done but i would like some interaction with Outlook so I can email the customer the completed templated (which will need to be in pdf form) straight from the database.

The interface needs to be very simple and as automated as possible since it will be used by an elderly lady.

Please ask any questions you may have.

エクセル マイクロソフトアクセス MySQL

プロジェクトID: #5491320

プロジェクトについて

36個の提案 リモートプロジェクト アクティブ Apr 4, 2014

36人のフリーランサーが、平均$240 で、この仕事に入札しています。

srinichal

I like to discuss further details about the project specifications and deliver the same to your needs .

$252 USD 3日以内
(37件のレビュー)
6.3
mail2vimalarora

Hi.. I have gone through details of your project requirement and feel comfortable in taking up the task. For your project, Access database can be used with .NET application that will be integrated with Outlook for the もっと

$244 USD 7日以内
(103件のレビュー)
5.9
winnet21

Hi, I am very interested your project I done similar project, please refer: https://www.freelancer.com/projects/C-Programming-Visual-Basic/Company-sales-production-software.htm Look forward to working with you!! もっと

$400 USD 25日以内
(32件のレビュー)
5.8
binayrs

Hello, I can build an automate system for you to achieve the the task you mentioned. Please consider my bid if you find my suitable for the project by reviewing my profile and experience. Best Regards,

$166 USD 7日以内
(30件のレビュー)
5.3
RBird

Custom sites Wordpress Sites, All programming languages and database types. Sites include administrative back end systems. Would love to help you, contact me so we can move forward.

$315 USD 5日以内
(4件のレビュー)
5.5
Vasilchenko

Hi We can offer two solutions . The first is the implementation Access's database. However, users will need to have direct access to the database. This can be a problem if you want to ensure security of your da もっと

$250 USD 7日以内
(41件のレビュー)
5.1
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 7 years in IT projects with 5 years working around Microsoft software もっと

$315 USD 6日以内
(15件のレビュー)
5.1
piyushdpatel

I have 8 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start Can You send me your Sample file or Project details ? if you want i will also send もっと

$222 USD 7日以内
(15件のレビュー)
4.9
elboukharimu

Hi, I'm very interested helping you creating and designing your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to ch もっと

$210 USD 3日以内
(31件のレビュー)
5.3
mrrapp

I have done much bigger versions of this type of a project for a distributor that receives Requests for Bids from the Army electronically. These are loaded into an Access database and the distributor then sends out RFQ もっと

$277 USD 3日以内
(6件のレビュー)
4.7
cedcont

Dear sir, Thanks for job posting. My name is Irene and I'm a doctor in economist. I am writing in reply to your advertisement. I have more than 10 years of admin work experience in the relevant field. My objectives t もっと

$222 USD 10日以内
(11件のレビュー)
4.3
infoshree80

Hello, Having more than 12 years of experience in development I have done so many project which is related to customer management. I have gone through your requirement and I am ready to start immediately. Please c もっと

$244 USD 17日以内
(19件のレビュー)
4.8
SHhadun

Hello, since you've put a mySQL, as one of technics to complete this project, can you please answer me few more questions, so I can propose you best way to do this job. I'm understanding that you allready have so もっと

$350 USD 4日以内
(22件のレビュー)
3.8
chyconsl

HI, I have done similar projects in the past. I will like to use my experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that y もっと

$147 USD 3日以内
(2件のレビュー)
2.9
ppn123

Hi, Good Day We are a team of professional developers in Asp.Net(VB.Net, C#.Net), HTML5, CSS3, JQuery, PHP,MySQL,SQL Server,Oracle,SharePoint, WordPress and Joomla and having many years of relevant experience i もっと

$277 USD 30日以内
(3件のレビュー)
3.2
zkutch

Hello. More 20 years programming experience. I can suggest ms sql server express edition, for example. It's free and in future you can upgrade it for full sql server, if will need. Regards. ------------------------- もっと

$150 USD 7日以内
(2件のレビュー)
2.4
SCKRamana

I am ready to develop database design as per below requirement もっと

$155 USD 3日以内
(5件のレビュー)
3.7
Dushyant211083

A proposal has not yet been provided

$277 USD 3日以内
(レビュー1件)
0.4
kashmoin

Hello I am new here so don't have any reviews about my work but i have 8 years of software engineering experience with me and i am dedicated and hard working individual. I can develop a system for your company us もっと

$166 USD 15日以内
(0件のレビュー)
0.0
AMANSPHERE

A proposal has not yet been provided

$155 USD 3日以内
(0件のレビュー)
0.0