In the last chapter you added and modified some forms for Kelly's Boutique. She would now like you to create some new reports. Make the following changes for Kelly using the ch 12-03_student_name file you created in Chapter 12. (Note: Open your chl2-03_student_name file and then save it as chl3-03_student_name before making the indicated changes.)
a. Kelly would like you to modify an existing query (Ch 11 Kelly Case h) to include the publisher name and then to save the new query as Ch 11 Kelly Case o. Use this new query to generate a report listing all of the field names provided in the query and grouped by publisher, sorted by book title, with no summarizing, in a stepped layout with portrait orientation. Save the newly created report as Ch 13 Kelly Case a and then print the report, making sure that all fields of information are clearly readable before printing.
b. Next, Kelly would like you to add some grouping to the report created in Case la. Rather than modify the existing report, create a new report using the Ch 11 Kelly Case o query to generate a report listing only the publisher, book title, quantity, and cost, grouped by publisher and sorted by book title, summing cost in a stepped layout with portrait orientation. Save the newly created report as Ch 13 Kelly Case b and then print the report, making sure that all fields of information are clearly readable before printing.
c. Next, Kelly would like you to use the parameter query created previously (Ch 11 Kelly Case 1) to create a report containing the fields book title and quantify for a specified publisher and viewed by Book Table, sorted by book title, with portrait orientation. Save the newly created report as Ch 13 Kelly Case c. Add a field to count the number of titles for the publisher specified and then sum the quantity of books for that publisher. Add line controls, change the report title, and move controls around so that your report looks like Figure 13.20.

Run the report for Random House and then print the report, making sure that all fields of information are clearly readable before printing.

Transcribed Image Text:

Book Title Green Eggs and Ham Hop on Pop The Cat in the Hat Quantity 15 8 4 Number of Titles: 3 Quantity of books: 27