Is there a software tool for a small-business database problem?
November 22, 2011 8:39 AM Subscribe
My office needs a seemingly simple database setup. I don't know what tool to use to set things up (or if we need to outsource it). Can the hivemind help?
posted by philosophygeek to Computers & Internet (12 answers total)
We have a small company (<10 employees), and we need to keep track of some metrics on our clients. Each week, approximately 5 staff members need to grade each client (around 40 active clients at any given time) on a 1-5 scale on a list of about 15 items. We'd like to move away from the paper-based solution of having each staff member fill out an evaluation form for each client each week and having one staff member collate the results in the appropriate files.
Is there a simple way (or relatively simple) to set up this kind of "database" (or pseudo-database; maybe an Excel spreadsheet will suffice)? One challenge is that we might have people adding their evaluations at the same time; I don't know how best to handle that scenario, or even if that's something we need to worry about.
We're a mostly Windows environment, but there are a couple of Macs. If necessary, the Mac folks can be asked to use a Windows computer for filling out these evaluations.
We're small enough (and plan to stay small enough) that we're not overly concerned about security for the database. If we can restrict staff members to only editing their evaluations, that's great, but if we can only say "don't edit other peoples' stuff," we can make that work.