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 chll-05_student_ name file you created in Chapter 11

a. 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 62-01296 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, Long boards, 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 65-00335 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 Gold coast are designated "Green" by the state. Place checks in the Green fields for those three manufacturers. Print the Anti-Hero 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

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 65-00358.
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 Long Board category.

Transcribed Image Text:

Form E Form Header Form E Detail ProductiD ProductName Price Discount roducNare