In my office we have a spreadsheet which we use to keep track of prices which we are quoted. This system seems to work rather well, but I'm sure it could be better. I have the following issues with our current system:
-Spreadsheets are only usable as spreadsheets. That information cannot really be put to use other than what it is currently doing.
-When we receive a quote we have to manually record (we add a comment box) what date and what time we were quoted
-Shared spreadsheets don't update immediately and two users can edit the same cell.
Therefore I think we would be better off creating a database. Unfortunately I know very little about databases and would like some advice.
#1, what type of database do I use?
#2, how would you structure the database? We have different vendors quoting us on a lot of products. As an example, we may have 4 vendors quoting us on 20 different digital cameras. The cameras may be different brands.
To have a better idea, our spreadsheet contains the following information:
Across the top row, different vendor names.
Down Column A, different model #s.
Each brand is separated into a different tab
Whenever we enter a price into that spreadsheet, we add a comment on excel with a timestamp.
I would like to have all of that info, and in addition I would like to have more fields if possible
Thanks in advance.