Đã hoàn thành

24306 Simple Access Database

Hi, I am looking for a Microsoft Access Database. The requirements are as follows: 1st Form - Purchasing Order Form Field Names - Order Number - I manually enter this field Product Name/Description Ordered From Order Date Order Price Available Rebate - Yes/No If Yes, a new text box appears where I can enter the rebate amount Comments Field 2nd Form - Receiving Reports Form - When I receive a product I previously purchased, I can enter the Order Number (from a combo box, and only orders that have not been received are in the drop down box) and once I select the order number I just received, I can enter the date received (current date) and also I can enter if the product had a rebate, the date I send the rebate. (Again, based on the order number I select from the drop down box should pull data from the Purchase Order Form automatically, for example, if the product has a rebate, a rebate date sent text box should be available, if no rebate was available, no text box should be present 3rd Form - Sales Order Form I can select from a combo box the product I sold, combo box should be for the product name and then I would like the following fields Sales Date, Shipping Date (current date)Sales Price, Order Price (should automatically populate based on the Purchase Orders table), EBAY Fee, Paypal Fee, Shipping Fee, Rebate Amount (again, automatically populated) and a calculated profit/loss field. All forms should have appropriate buttons, for example, a record button to record the purchase order, receiving, or sales order, a clear button that clears all fields, and a close button. Please use appropriate [url removed, login to view] options and auto dates when appropriate. Once I order a product, it gets entered into the inventory table once I enter the receiving report information, then I sell it, a delete query (probably ran once I hit the record button for sales)should remove the product from the table, or reduce the quantity by 1. I also need some way to update the 1st form when I receive a rebate (usually a 8 - 10 week lag between ordering product and receiving rebate) Quieries I would like to perform All products I have ordered on Purchase Orders that have not been received, please show the order number, product description, ordered from and order date fields All available rebates that have been submitted, but not received. Please show order number, product description, ordered from and date I mailed the rebate (based on the Receiving Reports form) A report that shows my total profit/loss whenever ran I am sure the requirements may change once I test the application, but I do not mind paying extra to ensure application works as desired. Thanks

Kĩ năng: Bất kì công việc gì, Visual Basic

Xem nhiều hơn: purchase order number example, inventory receiving form, ebay auto it, profit and loss report, microsoft access test, Ebay drop shipping , ebay auto sales, drop shipping ebay, calculated fields form, test forms application, simple query, inventory database, application microsoft access, access database, simple database visual basic, access delete, auto delete comments, paypal buttons options, update ebay inventory, paypal profit loss

Về Bên Thuê:
( 6 nhận xét )

ID dự án: #1774733

Được trao cho:


Hi sir i can do you application please read my PM thank you

$25 USD trong 2 ngày
(0 Đánh Giá)