Quote Tracking Database Needed

[chad13]

I tried to create a quote tracking database in Excel but soon realized that it may be more beneficial to do it in Access. I've never worked with Access other than for data entry into an existing database.
I searched for some templates but didn't find what I'm looking for.
I think what I'm looking for is a fairly simple database.

Here is what I'm looking for:

A simple data entry screen for:
Part Number <txt>
Description <txt>
Quantity <num>
Unit $ <$>
Date <date>
Validity <num>
Lead Time <num>
Vendor <txt>
Cage Code <txt>
Min Quantity <num>
ODC <$>
Bid Number <txt>
I would like to include a hyperlink to the actual hard quote saved where this database would be saved.

I want multiple users to enter quotes simultaneously.

Ultimately, as this gets up and running, I'd like to have a query that would generate a price list based on a parts list and quantity. This would 1st look for the bid number then the quantity closest to the quantity needed.

I know that I'm asking a lot but this would be a huge life saver.

Appreciate any help.

Thanks,

Chad

 

[jackd]

There are a lot of existing data models here.
I don't see anything specifically for Quotes, but I'm sure that, if you review a few models, you'll be in better shape to start designing your data base.
http://www.databaseanswers.org/data_models/index.htm

Getting you table structures set up properly before you get too far into queries, forms etc
is key to a successful database application.

There are a number of good references for things from
data base design, .... http://www.databaseanswers.org/approach2db_design.htm
naming conventions and tips... http://www.allenbrowne.com/casu-22.html
most everything ... http://www.rogersaccesslibrary.com/forum/topic238.html