DIY Customer Management System

O

oscarlets

Well-Known Member
Joined
Apr 14, 2012
Messages
417
Reaction score
8
Location
Polokwane
Hi,

I need help creating customer management system using excel or access :)

I need to create sth like this:

The system have customer information such as name,surname, contact, service bought, possible service I can provide for customer and value of customer,customer birthday,

I need to create sth that when I click on the customer all this information nicely display and if possible pie chart shows.

But I want to use excel or access or Google sheets (preferred) or any other free tool out there :)

Please share your advice :)

Your advice will highly be appreciated.
 
If all you need is that information, just make a standard excel sheet with those columns and then when you need to access a client, just do a search on them. and everything is in the same line. dont need a full aon "system" for this. its just a very basic list of info.
 
Sharepoint might be the answer to this. I don't use it myself but the guys here in the office do. I see them cooking up some fancy looking spreadsheet reports a lot.
 
oscarlets said:
Hi,

I need help creating customer management system using excel or access :)

I need to create sth like this:

The system have customer information such as name,surname, contact, service bought, possible service I can provide for customer and value of customer,customer birthday,

I need to create sth that when I click on the customer all this information nicely display and if possible pie chart shows.

But I want to use excel or access or Google sheets (preferred) or any other free tool out there :)

Please share your advice :)

Your advice will highly be appreciated.
Click to expand...

My advice is don't use those tools if expect more than 3 or 4 people requiring simultaneous access. Access is a "personal" database system.

These solutions require a lot of user cooperation. The wrong type of user, and you end up repairing things almost daily.

These packages do not manage concurrent access very well. If you are constrained to use them, host your excel documents on something like Sharepoint which allows you to retrieve previous versions. And Access..... don't do it. If you have to have a database, there is MySQL, Oracle Express and think SQL Server also has community edition.
 
Might something like this work for you:
https://en.wikipedia.org/wiki/Freedcamp

(I am not using it personally, but my wife is a big fan.)

And I agree with zippy, using the various "personal tools" is going to very painful in the long run as people break each others' data etc.
 
friedpiggy said:
If all you need is that information, just make a standard excel sheet with those columns and then when you need to access a client, just do a search on them. and everything is in the same line. dont need a full aon "system" for this. its just a very basic list of info.
Click to expand...

But I was hoping I could create sth that when I do search for customer, it shows a nice summary, such as last time we were in contact with the customer, what he or she bought, what we can sell etc
 
zippy said:
My advice is don't use those tools if expect more than 3 or 4 people requiring simultaneous access. Access is a "personal" database system.

These solutions require a lot of user cooperation. The wrong type of user, and you end up repairing things almost daily.

These packages do not manage concurrent access very well. If you are constrained to use them, host your excel documents on something like Sharepoint which allows you to retrieve previous versions. And Access..... don't do it. If you have to have a database, there is MySQL, Oracle Express and think SQL Server also has community edition.
Click to expand...

Thanks for sharing. SharePoint seems to be reliable. I will try your suggestion.
 
gkm said:
Might something like this work for you:
https://en.wikipedia.org/wiki/Freedcamp

(I am not using it personally, but my wife is a big fan.)

And I agree with zippy, using the various "personal tools" is going to very painful in the long run as people break each others' data etc.
Click to expand...

Sounds good. Hmm I will play around with it and see if it works for my primary needs. Thanks for sharing.
 
This is my Office365 Sharepoint console for Excel documents alone. As you can see there are a lot of options to work with.

Just to re-iterate, this whole area is just for EXCEL so yes.

Capture.jpg
 
I think you need an AWS ec2 cluster with expandable RDS.
Run NodeJs on the scalable frontend and have python/ROR on the backend interfacing to the RDS.
Nice API calls from node to backend. having the backend as an API will make it easy to plugin an angular/phoneapp app at a later stage.


Obviouslt this is the right way to do it!
 
No need to draw up invoices or statements? also keep in mind backup options to ensure they data is saved.
 
rward said:
I think you need an AWS ec2 cluster with expandable RDS.
Run NodeJs on the scalable frontend and have python/ROR on the backend interfacing to the RDS.
Nice API calls from node to backend. having the backend as an API will make it easy to plugin an angular/phoneapp app at a later stage.


Obviouslt this is the right way to do it!
Click to expand...

Funny guy !!
 
rward said:
I think you need an AWS ec2 cluster with expandable RDS.
Run NodeJs on the scalable frontend and have python/ROR on the backend interfacing to the RDS.
Nice API calls from node to backend. having the backend as an API will make it easy to plugin an angular/phoneapp app at a later stage.


Obviouslt this is the right way to do it!
Click to expand...

And don't forget the unit tests!

:D
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X