I would like to creat a basic Microsoft Access database that input customer orders from our online shop.
The shop will output the data in a comma seperated file with all the relevant contact, shipping and invoice information.
I would like to input this information directly from our shop and output the following as both print and e-mail
1. A simple invoice with the order details
2. A simple work order telling the shipping department
3. A packing slip
4. A shipping document
5. generate automatic e-mail to customer with status; for example , processing credit card, shipping and fedex number, on hold, shipped ...
We already have the forms in excel or word and we can send them to you
I would like the forms to be completed in one week if possible.