VISUAL BASIC USING VISUAL STUDIO-

1.Write a Visual Basic program to show the customer name and todays total amount purchase. If the customer did not purchase any item today, show 0 for the amount.

2.Write a Visual Basic program to show the items that need to be ordered to fulfil todays orders. Show the item name and the quantity to be ordered.

Orders and Inventory Management The database Microland.accdb is maintained by the Microland Computer Warehouse, a mail-order computer-supply company. Tables 10.9 through 10.11 show parts of three tables in the database. The table Customers identifies each customer by an ID number and gives, in addition to the name and address, the total amount of purchases during the current year prior to today. The table Inventory identifies each product in stock by an ID number and gives, in addition to its description and price (per unit), the quantity in stock at the beginning of the day. The table Orders gives the orders received today. Suppose that it is now the end of the day. Write a program that uses the three tables to do the following two tasks. First three records of the Customers table. Name Michael Smith Brittny Jones Warren Pease TABLE 10.9 CustID Street 2 Park St 5 2nd Ave 7 Maple St. it Dallas, TX 75201 Tampa, FL 33602 Boston, MA 02101 AmtPurchases 234.50 121.90 387.20 TABLE 10.10 First three records of the Inventory table itemID PL208 SW109 HW913 description Visual Basic MS Office Upgrade Scanner quantity price 89.50 195.95 49.95 12 TABLE 10.11 First four records of the Orders table iteml SW109 PL208 HW913 PL208 custI quantityy