I am looking to create a database that will contain about 15 columns and unlimited rows of data. I am open to a MS Access based solution or something else that is faster. The key is that is when I want to search for specific data, the results are displayed instantaneously. Right now I use excel and the filtering takes a bit too long for my liking.
I want to be able to add data to the new DB through an excel file or a tab delimited file or a CSV file. The DB should allow the user to use any of the three types of files.
I want a GUI screen to search the database.
I want to be able to search as preciously as I choose or as broadly as I choose.
I want to be able to export the whole database or a part of the database to excel if I choose to do so.
I am open to suggestions as to how I can best do this. If you choose a solution other than MS access based, please keep in mind that I don't want to purchase any new software. I have Windows 7 and Office 2010.
Please read the attached word document before bidding. I am not on Skype but I am available via IM from 9AM EDT to 5PM EDT most days.