Question Database Software

Access Denied

It was like that when I got here...
Joined
Jun 14, 2006
Messages
2,551
I've got a friend who's just started a business and he needs some database software. I know next to nothing about that so I'm asking you guys for recommendations. It needs to be able to:

Collate customer data.

Be searchable by name/telephone number etc

Allow you to add notes and book/change appointments

Not have it all on one page like the spreadsheets they're using right now.

Ta muchly.
 

caLLous

I am a FH squatter
Joined
Dec 23, 2003
Messages
18,236
Not having experience of anything else, I'd knock up an Access database. I made a pretty nifty one a couple of years ago for keeping track of stock in a friend's tile warehouse.
 

Moriath

I am a FH squatter
Joined
Dec 23, 2003
Messages
16,209
Oracle xe. But I would say that I work for them.

MySQL. Also free.

Any database can be made to do what you ask. It's a case of programming a front end for it. Which xe already kinda comes with and I think it's free.
 

Overdriven

Dumpster Fire of The South
FH Subscriber
Joined
Jan 23, 2004
Messages
12,533
If they're willing to go down the subscription route, I'd say go for Dynamics CRM 2013 Online and then use the out of the box functionality for this. Or SalesForce (But as I work with DCRM I'd say Dynamics) - Both offer 30 day trials etc.

If you want to go on-prem and have the server/desktop space laying around then what both @Deebs and @Moriath have said. MySQL with necessary plugins. There are other options available, but these are probably the better ones. Loads of downloadable customer management tools available to use etc.

All down to budget and space honestly.

Cheeky edit:
I'll do the customisation work for half price if you go down the CRM route ;)
 

Bob007

Prince Among Men
Joined
Dec 22, 2003
Messages
585
MSSQL 2012 express with advanced services
http://www.microsoft.com/en-gb/download/details.aspx?id=1842
And Spendid CRM
http://www.splendidcrm.com/Products/Editions/SplendidCRMCommunity.aspx

For that you get a Customer relations manager, individual logins per user (handy with growth) and SQL server reporting services. So you can write reports based on the data in the DB.

Total cost = £0
But is MS, So you might want to dedicate a box to run it all.

*10 gig limit on DB's in express. resource hungry. It will grab what it can.
 

Users who are viewing this thread

Top Bottom