In the last chapter you added and modified some queries for Kelly's Boutique. She would now like

Question:

In the last chapter you added and modified some queries for Kelly's Boutique. She would now like you to create some new forms. Make the following changes for Kelly using the chl l-03_student_name file you created in Chapter 11. {Note: Open your chl 1 -03 student_name file and then save it as chl2-03_student_name before making the indicated changes.)

a. Create a form to look like Figure. Save the form as Ch 12 Kelly Case a. Print record 3

b. Create a list box control using the form created in part a. This control should provide the user with a list of departments: Adult, Children. Move the picture control down to make room for the list box control.

In the last chapter you added and modified some queries

c. Create a combo box control using the form created in part a. This control should provide the user with a list of departments (as in b above) but with a combo box instead of a list box. Dept choices should be Adult, Children, and Teen. Save the modified form as Ch 12 Kelly Case c. Print the documenter page that documents the combo box for Dept.
d. Create a special combo box control using the Book Form. This control should provide the user with a dynamic list of publishers based on the publishers listed in the Publisher table. The combo box should list publisher number and name, and referential integrity must be enforced. Label the combo box column Publisher. Save the modified form as Ch 12 Kelly Case d. Print the documenter page that documents the combo box for Publisher.
e. Using the Book Form, create a calculated control to compute the total retail value of each book in stock. First add the quantity field to the form and then add the calculated control. Format the control in currency, and label the control Total Retail Value. Save the modified form as Ch 12 Kelly Case e. Print the record containing the book title "Angela's Ashes"
f. Using the Book Form, create a check box control to indicate whether or not the text is a bestseller. Label the field and control Best Seller. Mark the book Green Eggs and Ham as a bestseller using your new form. Print the record that contains the book title "Green Eggs and Ham" and then save the modified form as Ch 12 Kelly Case f.
g. Create a form and sub form that shows all books by publisher, listing ISBN and Book Title in datasheet layout. Then save the modified form and sub form as Ch 12 Kelly Case g and Ch 12 Kelly Case g Sub form. Print the record with Arthur A. Levine Books as the publisher.