Rosey€™s Roses is interested in more effectively managing their inventory. They would like you to put together a database of their current inventory. Create a new database file using the information below. Name the file ch9-06_student_name (replacing student_name with your name).
a. Use the information below to create and print three tables€”Products, Type, and Grower€”as you did earlier in this chapter.

b. Establish the appropriate relationship between each table and then print the relationships report.
c. Create and print a query using the Simple Query Wizard that lists the product description, type, and grower name for all products. (Save as Query 1.)
d. Create and print a form using the Form Wizard for entering new products that lists all the available fields in the product table; use whatever style you€™d like. (Save the form as Form 1, and print the first record only.)
e. Create and print a report using the Report Wizard with the fields ID, type, description, and grower name for all products. The report should be viewed by grower sorted by ID in ascending order and be formatted in a Stepped layout with Portrait orientation. (Save the report as Report 1.) All field information should be visible.

Table Structure: Primary Key? Table Field Name Data Type Product ID Number Yes Type Description Quantity Cost/Unit Short Text Short Text Number Currency Grower ID Number Short Text Type Type Description Yes Long Text Grower Grower ID Number Yes Short Text Grower Name Contact Short Text Products: Description ID Type Quantity Cost/Unit Grower ID Abraham Darby #s Be My Baby #5 Deja Blu #5 Mongo Peach Drift #10 Shrub 25 $39.99 100 Shrub 2 30 $18.99 100 Shrub 18 $25.99 200 Shrub 38 $47.99 300 Shrub 33 $12.99 200 $ 6.99 Shrub Red Drift #10 15 100 Shrub Sedona #5 $14.99 200 $ 9.99 8. Shrub Sweet Intoxication #5 17 300 9. Shrub Wing Ding #5 Climbing Orange Crush #7 Don Juan Climber #5 30 $11.99 300 10 Climber 16 $32.99 100 11 Climber 25 $37.99 200 12 Tree Barbara Streisand 36in Tree 50 $52.99 300 Firefighter 36in Tree Trumpeter 36in Tree 13 Tree 14 $55.99 200 14 Tree $65.99 100 Type: Type Description Climber Climbing roses that are trained upright will tend to bloom only at the tips, and will not generate laterals. Other terms that are commonly used are climbers, ramblers, pillar roses, etc. There is no "official" definition of these terms. Generally, climbing roses are repeat blooming roses with large, stiff canes. Shrub Rose shrubs that are not classified under the common varieties are known as shrub roses. Shrub roses are available in many different varieties, colors, and sizes. Tree A rose tree is a rose bush that is pruned and grafted to grow as a tree. It has a long trunk with foliage and flower growth in a rounded mass at the top of the trunk. Grower: Grower Name Grower ID Contact 100 200 Jackson & Perkins Nate Rexford Passion Growers Kyle Said Casey Crawford 300 Passion Heights