we are using Access DB and VB.net

00 1 TBL_ORDER_DETAILS 1 FLD_ORDER_ID 1 FLD PRODUCT_ID FLD QUANTITY 00 00 18 18 1- 00 TBL_PRODUCTS FLD_PRODUCT_ID FLD_PRODUCT_NAME FLD_MANUFACTURER FLD_CATEGORY FLD_PRICE FLD STOCK QUANTITY FLD_PRODUCT_WARRANTY FLD_PRODUCT_TAX_PERCENT FLD_PRODUCT_RATING TBL_ORDERS 1 FLD_ORDER_ID FLD CUSTOMER_ID FLD_STAFF_ID FLD_PAYMENT_METHOD FLD_PAYMENT_STATUS FLD_ORDER_STATUS FLD_ORDER_DATE_TIME TBL_CUSTOMER 7 FLD CUSTOMER_ID FLD_FIRST_NAME FLD_LAST_NAME FLD_SEX FLD_DOB FLD_LOCATION FLD_PHONE_NUMBER FLD_EMAIL TBL STAFF FLD STAFF_ID FLD_FIRST_NAME FLD_LAST_NAME FLD_POSITION FLD SEX FLD_PHONE_NUMBER FLD_EMAIL SALINAN INVOIN No. 1002 Aspirasi Komunikasi Enterprise BI 2-1. Blok Wisma seringkalan 30 Kota Kinabalu, Sabah Tel: ORS-765223 Faks: O-765123 E-mel: aspirasikomabah.net.my TASK 1: Build a form for the user to MAKE ORDERS for multiple products. 1. The ORDER for multiple products must be made in a single form, using a single ORDER ID. 2. The MAKE ORDER form must show/display calculated values such as SUB-TOTALS and TOTALS. However, these calculated values do not need to be stored in the database. 3. The ORDER for products must be processed as a TRANSACTION. 4. When entering data into the MAKE ORDER form, all items in the order must be successfully COMMITed into the database, or ROLLED-BACK completely if there is an error. IMPORTANT: Your evaluator will test ACID compliance of your ORDER TRANSACTION by deliberately causing an error when entering data for the order. Jaja Handphone Shop No.133, Jalan Bakti Taman Industri Licas 2 88838 Kota Kinabalu, Sabah No. Pes: P0045 Tarikh : 8 Ogos 2006 Buti Marge Ben NZX smartphone NZX-23 NZX literio (RM) 980.00 4 unit 6-10.00 760 00 Jumlah Kasar Diskman Ning 10 Jumlah Bersih Jurah (HM) 4,900.00 2,560.00 50-1000 10,500.00 1,050.00 9,450.00 Tola Ringgit Malaysia: Sambilan Ribu Empat Ratu Lima Puluh Sahaja Sarah An dib. Syarat: Diskaun uni 107 hi 396 14 hari K&K di Pas TASK 2: Build a form that the user can use to VIEW existing ORDERS. 1. This VIEW ORDER form is only used to look at existing ORDERS already in the database, and to look at the list of products ordered in each ORDER. 2. Both your MAKE ORDER form and VIEW ORDER form should look something like FIGURE 1 (it does not need to be identical). FIGURE 1: Approximate appearance of your MAKE ORDER and VIEW ORDER form