Slashdot Mirror
Ask Slashdot: Easy-To-Use Alternative To MS Access For a Charity's Database?
New submitter danzvash (447536) writes "I'm doing some volunteering for a street kids charity in Senegal, West Africa, and they need a new database to store all their information for the kids, and to help the funding organizations like UNICEF. The charity staff have a few computers running Windows 7. Being a die-hard OSS geek I'm more inclined to knock up a MySQL backend with a Django (or similar) front-end and run the whole thing from a reliable VPS. But it needs to be understandable by the non-geeks in the charity — there is no IT expertise here. Is there anything that can allow me to design and edit databases, tables, and forms but doesn't require an MS license?"
I think the question might be asked backwards, here. If there is really no IT expertise there, then is Access actually going to get them anything? You might be better off setting them up with something much simpler (for example a spreadsheet) unless they need to be able to connect to it from multiple systems simultaneously or have other requirements that a spreadsheet cannot match.
Don't make your problem more difficult than it needs to be... If you give them software that they can't use then most likely they will stop using it once you are on the plane.
Damn_registrars has no butt-hole. Damn_registrars has no use for a butt-hole.
There is too little information given to decide what product solution is "best' for this situation.
Note cards work, Spreadsheet is often enough for "simple" databases. Access and similar are good for designing a good front end (not for the database) and so on.
From the sounds of it (reading between the lines), a good CRM like SugarCRM might actually be a better solution. However without more information, any recommendation is pure guessing at this point.
Agent K: A *person* is smart. People are dumb, stupid, panicky animals, and you know it.
BS. Access is a terrible database to use as a back-end for real software doing something complex, but it's great as a single-user tool with its own UI.
While a spreadsheet might be more accessible to non-geeks, Access tries pretty hard to give a low-learning-curve to making simple queries and simple GUIs to show the results of queries, or make simple table edits.
I suspect the OP could make a spreadsheet work, however.
Socialism: a lie told by totalitarians and believed by fools.
"I'm doing some volunteering for a street kids charity in Senegal, West Africa, and they need a new database to store all their information for the kids, and to help the funding organizations like UNICEF"
Suppose a department in the company you're working for came to you and said "We want a database to store information, and we want to do it with Lotus Notes". Would your first response be start implementing Lotus Notes, or would it be to say "Umm, just a sec here. Why do you think you need a database?" and "What kind of data, how much data will there be, what do you want to do with it?"
Of course, that's one of the most annoying things that IT people do: ignore your question and try to help solve your actual problem. I apologize now.
For one thing, your problem may already have been solved for someone else.
Are we talking about committing to paying monthly fees for a VPS server? If so, I do not see why the problem with paying for MS Access licenses.
My other question is, if we're talking about about a few PC's running Windows 7 and zero-tech knowledge, how are you going to handle backups and restores of the mysql database and the custom apps?
With MS Access or Excel, you can do backups and restores to/from a CD-ROM, or to a USB stick with a trivially easy restore that anyone could assist with over the phone. With SQL Server Express and some other suggestions, not so easy.
>Being a die-hard OSS geek
I guess the root of the problem is the submitter then. The charity needs to replace them with a less-biased person so the best decision can be made, whether that be OSS or a free-or-cheap charity license for Access.
My general guidelines, for data storage, Fields A, B, through Z by $X records
is $X > 10,000 records? - If Yes use a DB if No see Next Question
Do I need separate out data by type or access, such as Joe can see Name, DOB, Telephone number, Address, Emergency contact info etc. But Jane should only see Name, and Emergency Contact? - If Yes use a DB if No see Next Question
Will more than 1 user need to write data at to this at the same time? If Yes use a DB if No see Next Question
Will more than have users need to read data from this at the same time or will anyone need to read real time changes data? If Yes use a DB if No see Next Question
If you have answered No to all of the above questions, Then use a spreadsheet.