I need a database-like software for a business, it can be web-based or offline, I'm just stuck on which one is best for my purposes. I'm not even sure if Database is the right word describing the type of software. I'm moderately tech-savvy, definitely not a tech geek, so I can't create this myself from scratch.
So imagine a database that can list hundreds of people with detailed profiles (a unique page per person), say clients. There are multiple categories of people. Say, the business who lists these clients is a medical office. The categories of people include: age, gender, ethnicity, diagnosis, number of visits, symptoms, prescriptions, results (+). Each client profile provides information about each of these with clicable links or tags which will take you to the rest of the clients in that category. For example, a client John Doe, white, is 34 years old with a stomach ulcers, has been to the clinic twice, with heartburns, stomachaches and indigestion prescribed antibiotics with results yet to arrive. When you click on "stomach ulcers", it will take you to the list of clients with stomach ulcers, if you click on "indigestion", it'll take you to the list of clients with indigestion. I would be even better if the program creates the lists automatically. Maybe sorta like Tumblr.
I can create a website, but it will cost money annually, and free web hosts give you limited resources that cannot accommodate this kind of database. I can work with Excel or Access, but I'm not that familiar with Access, and don't really have time to figure it out on my own. Any input will be appreciated!
Edited by Distracted, 29 September 2013 - 10:12 PM.