ACCESS Database

Closed Posted Feb 26, 2006 Paid on delivery
Closed Paid on delivery

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.

## Deliverables

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.

## Platform

Must be able to run on a Windowes Platforms

Engineering Excel Microsoft Access Microsoft Exchange MySQL PHP Powerpoint Software Architecture Software Testing Word

Project ID: #3313262

About the project

23 proposals Remote project Active Mar 19, 2006

23 freelancers are bidding on average $869 for this job

pShankar2

See private message.

$170 USD in 30 days
(409 Reviews)
7.1
shaddadfalcon

See private message.

$127.5 USD in 30 days
(110 Reviews)
7.0
ghumber

See private message.

$212.5 USD in 30 days
(108 Reviews)
5.9
ahmedkhalif

See private message.

$318.75 USD in 30 days
(34 Reviews)
5.8
sondravw

See private message.

$212.5 USD in 30 days
(11 Reviews)
4.6
thinkandcare

See private message.

$93.5 USD in 30 days
(24 Reviews)
4.5
simmy

See private message.

$467.5 USD in 30 days
(20 Reviews)
4.2
melan

See private message.

$255 USD in 30 days
(8 Reviews)
3.9
nvvw

See private message.

$72.25 USD in 30 days
(12 Reviews)
3.7
goldenscript

See private message.

$75.65 USD in 30 days
(9 Reviews)
3.1
oruckenaneu

See private message.

$212.5 USD in 30 days
(4 Reviews)
2.5
theossie

See private message.

$25.5 USD in 30 days
(5 Reviews)
1.9
bluegenesol

See private message.

$59.5 USD in 30 days
(13 Reviews)
1.0
mshaza

See private message.

$153 USD in 30 days
(3 Reviews)
0.7
myinformati

See private message.

$12.75 USD in 30 days
(3 Reviews)
0.0
vw1883195vw

See private message.

$145.35 USD in 30 days
(1 Review)
0.0
sudhakersamuel

See private message.

$38.25 USD in 30 days
(2 Reviews)
0.0
SReynolds73

See private message.

$85 USD in 30 days
(0 Reviews)
0.0
DesigningSystems

See private message.

$4887.5 USD in 30 days
(0 Reviews)
0.0
gkpvw

See private message.

$11900 USD in 30 days
(0 Reviews)
0.0