Roseys Roses is interested in more effectively managing their inventory. They would like you to put together

Question:

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.

Table Structure: Primary Key? Table Field Name Data Type Product ID Number Yes Type Description Quantity Cost/Unit Short

Type: Type Description Climber Climbing roses that are trained upright will tend to bloom only at the tips, and will not

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.