Create Database to hold price quote

January 8, 2009 at 20:24:13
Specs: Windows XP, N/A
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

Thanks in advance.

See More: Create Database to hold price quote

Report •

January 11, 2009 at 03:09:00
Your database starts from Items.
Then one for Vendors.
Then one for Quotes.

Report •

January 11, 2009 at 20:38:04
What type of database do you recommend?

Report •

January 12, 2009 at 02:15:41
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.

Report •

Related Solutions

Ask Question