Rosey’s Roses. Now the company would like you to help it create some forms to illustrate information from the database. Make the following changes using the ch11-06_student_name file you created in Chapter 11. (Open your ch11-06_student_name file and then save it as ch12-06_student_name before making the indicated changes.)
a. Note the existing relationships between existing tables. Now delete those relationships, and then change the field size of ID, Quantity, Quote Number, Quantity Ordered, and GrowerID to integer with 0 decimal places, Cost/Unit to currency with 2 decimal places, Customer Number to a field size of 5, Type to field size of 10, and Grower Name and Contact to field size 40. Now reestablish the relationships you previously deleted enforcing referential integrity. Use the Forms Wizard to create a new form that includes the ID, Product Description, Type, Type Description, Grower Name, Quantity, and Picture fields. View the data in a columnar layout with no grouping. Save your form as Form A and then navigate to ID 1 and print that record only.
b. Modify the form you created and saved in (a) by changing the Type field text box to a list box control that provides a list of all Types: Climber, Creeper, Shrub, and Tree. Move the fields below Type 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 product ID 1 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 Grower ID a combo box control that provides a list of all Grower IDs: 100, 200, 300, and 400. Print the documenter page that documents the new combo box control.
d. Modify the form you created and saved in (c) by removing the existing GrowerID field combo box control and creating a new GrowerID field special combo box control based on the GrowerID and Grower Name fields of the Grower table. The field should use the GrowerID and Grower Name fields of the Grower table and then just list the Grower Name when activated. (Don’t forget to modify the relation-ships first and then re-establish referential integrity.) Change the title of the form to Form D and then save the modified form as Form D; then print the documenter page that documents the new special combo box control.
e. Add a new data type Yes/No field titled Organically Grown to the Grower table and then create a new form containing all the fields in the Grower table in columnar format titled Form E. Currently only Owen Farms and Passion Growers are designated ‘‘Organically Grown’’ by the state. Place checks in the Organically Grown field for those growers. Print the Passion Growers Form E.
f. Create a new form with a subform containing the fields Grower Name, Product Description, Cost/Unit, and Type viewing the data by Grower in a Datasheet layout and form title Products by Grower and subform title Product Subform. Resize the fields displayed in the subform and then print the form for the Passion Growers grower.