Which tool/programming/db should i use?

Years ago, I had a similar situation and needed a no expense, quick and easy solution. Our network had MS Office available (as most businesses do) so I created an Excel workbook containing worksheets that simulated mini databases (so to speak) allowing the end-user's to search, sort, report and filter the data of their interest.

Microsoft Excel is a very simple and handy tool to use for creating searchable records and also offers ease with uploading information into CRM's and other databases. Most end user?s are familiar with spreadsheets and even a novice user can manipulate sorts and print reports with little training.

Create an Excel spreadsheet with a column heading for each category of your details. Like Name would be in one column, Address another column, etc. Once you are satisfied with the column headings, then from the main menu select: ?Insert --> Define --> Name?. A panel will appear with 'Names in workbook' and the spreadsheet address, click on OK. Now the spreadsheet is like a self-contained database that can be searched upon, sorted, and reported upon to the end user?s content. Remember too, it is always helpful to the end-user to have the reporting already set up and formatted for them.

Like I said, this is only a ?quick and dirty? solution. Without knowing more specific information from you in regard to what software and budgeting is available, your target audience, and the frequency of the data submittals, etc., using an Excel workbook may or may not be the right solution. Keep in mind that for long-term purposes, maintaining an Excel workbook/database can be a nightmare and not the best solution.

Hope this helps!