MICROSOFT ACCESS

In this task, part of the VBA code for the Orders screen is written. to. The order date must be today's date (if necessary, you can change). For example, if the order is placed on July 5, 2019, it will appear by default in that date textbox, but that can be changed if necessary. The textbox must NOT appear empty in the form. b. Enter the ID of the client who makes the order, and the system should show it in a label the name of that customer (look it up in the table). c. Enter the ID of the product you want in the order and the system should show the price of that product and the name of the product (look for it in the table). d. Enter the number of products you are interested in buying and the system must verify that quantity is available. and. VBA code can be placed in buttons or in textbox events (for example LostFocus, On_Click, etc). VBA MS-Access Code Assignment SICI 3028 - Applied Programming F. Show errors when needed: i. If the customer does not exist (ID is not in the table) ii. If the product does not exist (ID is not in the table) iii. If the requested quantity is not available (there is less in the table) iv. In any of these cases, the order should NOT be allowed. For For example, the button to register the order that is not available, change the content of the textbox after presenting the error, etc.