I have an Excel spreadsheet I use as a keeper of records; 100 unique rows/records with approximately 10 columns of data. These columns are filled with 2 digit codes, a word or short phrase. So using Excel was effective. However I will be adding 2 or 3 additional columns to this spreadsheet that will be text oriented (one cell could have multiple paragraphs of text). I need to move away from Excel and I know I could use Access with some enhanced reporting, but I would rather use a vended product that is designed for this type of work. Best I can describe what I am looking for is an electronic file cabinet.
In summary; I am looking for suggestions for a vended software that can house a small database (two hundred records max) with 10 – 15 bits of data per record, some records would be numerical, some would be lengthy text (let’s say 1000 words per). Would need to be flexible to generate a report in a summary fashion (all records with a subset of data), and be able to generate a single record report that shows all data including the lengthy text.
Any ideas? Thanks!
Bookmarks