[SOLVED] In the last chapter you created some

In the last chapter you created some queries for the Snickâ€™s Board Shop. Now Caitlin would like you to help her create some forms to view information from the database. Make the following changes for Caitlin using the ch11-05_student_name file you created in Chapter 11. (Note: Open your ch11-05_student_name file and then save it as ch12-05_student_name before making the indicated changes.) a. Note the existing relationships between the Product, Manufacturer, and Category tables. Now delete those relationships, and then change the field size of Product ID to 10, Product Name to 35, Manufacturer ID to 10, Style to 15, Category Name to 25, Manufacturer Name to 25, and Phone Number to 15. Now reestablish the relationships you previously deleted enforcing referential integrity. Use the Forms Wizard to create a new form that includes the Product ID, Product Name, Category Name, Manufacturer Name, Price, Style, Quantity, and Picture fields. View the data by Product in a columnar layout. Name your form Form A and then navigate to Product ID 61-16758 and print that record only. b. Modify the form you created and saved in (a) by changing the Category Name text box to a list box control that provides a list of all Categories: Complete, Ramp, Longboards, Protective Gear, Rails, and T-Shirts. Move the fields below Category Name down so all are viewable on the form. Change the title of the form to Form B in the form header and then save the modified form as Form B. Print the record containing 61-16758 only. c. Create a new form containing all of the fields from the product table in columnar layout with a title of Form C.Make the Manufacturer ID a combo box control based on the Manufacturer ID field of the Manufacturer table. Print the documenter page that documents the new combo box. d. Add a new data type Yes/No field titled Green to the Manufacturer table and then add a new form containing all the fields in the Manufacturer table in columnar format titled Form D. The new Green field designates whether a manufacturer has qualified for the energy-saving status granted by the state. Currently only Zero, Anti-Hero, and Board pusher are designated â€˜â€˜Greenâ€™â€™ by the state. Place checks in the Green fields for those three manufacturers. Print the Board pusher record. e. Create a new form containing the Product ID, Product Name, Price, Discount, and Picture fields viewed by Product in a Columnar layout titled Form E. Delete the Picture label and move the picture control to the right hand side of the form. Resize the Product Name and Price fields so that your form looks like Figure 12.43: Now add a new calculated control titled Discounted Price and formatted as currency below the Discount field to compute the discounted price (Price less discount, if any). Print the record for Product ID 61-16758. f. Create a new form with a sub-form containing the fields Category- Name, Product Name, Price, and Style viewing the data by Category is a Datasheet layout and title Form F. Resize the fields displayed in the sub-form and then print the form for the complete category. g. Make sure you keep a copy of this file for use in the next chapter. Figure 12.43:

Question: In the last chapter you created some