I would like a simple access data base set up with the following scenario:I have been asked to design a computerized accounting system for a small company that sells specialty baby furniture. The following pieces are currently in their inventory:
1. Cherry Deluxe Crib
2. Oak Crib
3. Cherry Changing Table
4. Oak Changing Table
5. Cherry Dresser
6. Oak Dresser
A customer can only order one of these items in a given order, and must pay for the item before it is shipped. The company accepts personal checks, Visa, or MasterCard. The system is required to collect the following information about its customers: Customer name, address, and phone.
Shipping charges are paid by the customer directly to the shipping company.
1. Create an ERD in Excel or Word of the system that you have been asked to design.
2. Set up the appropriate tables in Access for this system.
3. Create a form to input customer orders
4. Create a form to input inventory items
5. Create a splash screen to enter the system
6. Create a report to print monthly sales
7. Create a report to print customer receipt
8. Create a report to print packing slip
10. Create a user-guide modified: only create a detailed user guide for
one section (i.e. input customer order), however provide sample reports for the entire project.
Please inform me of the cost and the earliest time frame I could expect to have this completed. If at all possible, I need this by 5:00 pm today Dec,
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).