Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
Hello all.
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
They are:
Item condition
Delivery time
Minimum qty
Qty available
Warranty
Voltage
Thanks in advance.
Regards,
Andy

Any good database will work. I'm partial to old databases like dbase3 or foxpro. Current databases like access or an sql type will work.

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |