In the last chapter you modified some queries for the Wine Depot. Now Barbara would like you

Question:

In the last chapter you modified some queries for the Wine Depot. Now Barbara would like you to help her create some new forms. Make the following changes for Barbara using the chl l-04_student_name file you created in Chapter 11.

a. Change the Type field in the Wine Products table to a text type with a field size of 30. Use the Forms Wizard to create a new form from the Wine Products table and Winery Table that includes the following fields: SKU, Cost, Price, Quantity, Size, Vintage, Type, Picture, and Winery Name. Use a justified layout and entitle the form Wine Products; then modify the form to look like Figure 12.42. Save this form as Ch 12 Wine Depot Case a. Navigate to SKU 14539 and print that selected record only.

b. Modify the form you created and saved in a above by changing the Type text box to a list box control that provides a list of all wine types: Cabernet Sauvignon, Chardonnay, Fume Blanc, Merlot, Pinot Noir, Sauvignon Blanc, Syrah, Red Chianti, and Zinfandel. Save the modified form as Ch 12 Wine Depot Case b. Print the record containing SKU 12895 only.
c. Modify the form you created in part b by replacing the Winery Name field with a Winery field (from the Winery Table). Then change the Winery text box to a combo box control that provides a drop-down list of all 21 wineries. Your new combo box should contain a value list that you create listing each winery by number. For example: 1,2,3 etc. Save the modified form as Ch 12 Wine Depot Case c. Print the documenter page that documents the combo box for Winery.
d. Modify the form you created in part c by deleting the Winery combo box control and replacing it with a Winery combo box control based on the winery and name fields in the Winery Table. The field should use the winery and name fields of the Winery Table and then list the winery name when requested. (Don't forget to modify the relationships window first and then to reestablish referential integrity!) Save the modified form as Ch 12 Wine Depot Case d. Print the documenter page that documents the new combo box for Winery.
e. Modify the form you created in part d by adding a check box control in the lower right-hand corner of the form to indicate if this product has been recommended by the Wine Spectator (a noted magazine of wine-tasting professionals). Label the field and control "Wine Spectator Recommended". (Hint: Don't forget to create a field in the Wine Products Table first.) Only three wines currently have that designation: SKU 11475, 13883, and 15347. Save the modified form as Ch 12 Wine Depot Case e, and print the record containing SKU 15347 only.
f. Modify the form you created in part e by adding a calculated control below the Winery Name to compute the total cost in inventory of each product (cost times quantity). Format the control in currency and label the control Total Cost. Save the modified form as Ch 12 Wine Depot Case f. print the record containing SKU 11475 only.
g. Create a new form with a sub form using the Winery Table and Wine Products Table. Use the Winery Name field from the Winery Table and the SKU and Type fields from the Wine Products table. View the data by winery in a datasheet layout. Use the default names provided for the form and sub form. Save the modified form as Ch 12 Wine Depot Case g. Print the record containing the Melville winery only.