Computing.Net > Forums > Database > Create Database to hold price quote

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Create Database to hold price quote

Reply to Message Icon

Name: pt80chip
Date: January 8, 2009 at 20:24:13 Pacific
OS: Windows XP
CPU/Ram: N/A
Product: N/a / N/A
Subcategory: General
Comment:

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



Sponsored Link
Ads by Google

Response Number 1
Name: wizard-fred
Date: January 11, 2009 at 03:09:00 Pacific
Reply:

Your database starts from Items.
Then one for Vendors.
Then one for Quotes.


0

Response Number 2
Name: pt80chip
Date: January 11, 2009 at 20:38:04 Pacific
Reply:

Wizard,
What type of database do you recommend?


0

Response Number 3
Name: wizard-fred
Date: January 12, 2009 at 02:15:41 Pacific
Reply:

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.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

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


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Create Database to hold price quote

Sync online database to offline dat www.computing.net/answers/dbase/sync-online-database-to-offline-dat/155.html

New to MYSQL trying something out www.computing.net/answers/dbase/new-to-mysql-trying-something-out/385.html

mdb conversion to cdb www.computing.net/answers/dbase/mdb-conversion-to-cdb/329.html