CASE ANALYSES 16-22. A Form for BSN Suppliers (Creating a Simple Form in Access) The BSN Company requires a form with which to view its existing suppliers conveniently and also to create records for new suppliers. Figure 16-16 contains a suggested format for this form. Requirements 1. Using the Vendors table in the BSN database that accompanies this book, create the initial form using the Form Wizard. Note that you will have to reposition some of the data fields in the form, add the term "Abbrev." to the label for the State field, and add the following items in the heading of the form: (1) a label with text "BSN Vendors," (2) a label with your name, and (3) a graphic (which can be different than the one shown in the figure). 2. Run your completed form to make sure that it works. What is the first record that shows in your form? What is the last record? 3. While in run mode, tab through the individual data fields of any particular record and note that you do not tab through the data fields column by column. Return to design view and adjust the tab order by selecting View/Tab Order from the main menu and make the necessary adjustments. What is the correct Tab Order, and how did you make these adjustments?CHAPTER 16 / Database Forms and Reports 511 BSN Vendors Prepared by (your name here) Vendor ID 3450 Contiet Peron Your name here Fedor Name Start Addom #1 1234 Staph Avero Sooner AdJoins #2 CHer Suite (Abbire.) MD Zip Code 12345 FIGURE 16-16 A form for entering and viewing vendor information in the BSN database. 4. Go back to run mode for your form and click on the * symbol to add the information in Figure 16-16 to the Vendors table. Note that you should use your own name as the Contact Person for this vendor. 5. Print just this form to document your work, following the steps in the text for this task. 6. Now that you have used your new form, what additional improvements would you make to further streamline data-entry tasks