I receive quotes for items from several vendors and then offer these to a group of buyers. The vendors may have the same or different items. Items contain several pieces of information. ie: I may have the item of a Cubic Zircon, Round, Faceted, 3mm, red; cubic zircon, round, unfaceted, 3mm, red. I need an Acess database to maintain items offered and create spreasheets of items I'm selling to the buyers.
See attached files for how I envision this working along with a currently used spreadsheet.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4 - I need an Access database that will keep track of the vendors and their products.
5 - I want to be able to select a vendor and have their items displayed.
6 - I want to be able to select the items to offer for sale.
7 - I would like to output those selected items to an Excel spreadsheet. I have a spreadsheet that I am already usning. I would like to output the data in the same format as the current spreadsheet.
7a - Some buyers do not have the ability to read an Excel spreadsheet. I would like to have a plain text copy of the spreadsheet created for them to view.
8 - At the time of exporting I want to enter in the markup amount, ie: 2 for 2 times the cost, and have this output as the selling price.
9 - When the purchase time is complete I would like to be able to import the spreadsheet back into the Access database.
10 - From the imported data I would like to create invoices to the buyers and send a copy to them via email, and print a copy for my use in filling the orders. (email address is in the spreadsheet)
11 - NO accounting data needs to be kept.
12 - If someone does not get their invoice I need to be able to send that one out indivudually.
13 - I would like to keep track of the quantity of items sold so I can be sure to include them when selling again. (item 4)
14 - I would like to create a complete spreadsheet of the items ordered to send to the vendor.
Must be able to run on a Windowes Platforms