Review Assignment -
Kimberly wants you to create a custom report for the Supplier database that prints all companies and the products they offer. She also wants you to customize an existing report. Complete the following steps:
1. Open the Supplier database you worked with in the previous two modules.
2. Modify the rptSupplierDetails report by completing the following steps:
a. Change the report title to Riverview Suppliers.
b. Remove the alternate row color from the detail lines in the report.
c. Change the first column heading to Supplier ID. Change the fifth column heading to First Name and the sixth column heading to Last Name.
d. In the Report Footer section, add a grand total count of the number of suppliers that appear in the report, make sure the calculated control box has a transparent border, and left-align the count with the left edge of the CompanyName field value box. Left-align the count value in the calculated control box.
e. Add a label that contains the text Suppliers: to the left of the count of the total number of suppliers, aligned to the left margin, and aligned with the bottom of the count calculated control box.
f. Set the margins to Normal, and adjust the width of the grid to 7.8 inches. Adjust the width of the controls in the Report Header to accommodate the corresponding data, ending up one grid point to the left of the width of the right margin.
g. Move the page number control to the left until it is one grid dot to the left of the right margin. Right-align the page number value in the control box.
3. After you've completed and saved your modifications to the rptSupplierDetails report, filter the report in Report view, selecting all records that contain the word "supplies" in the Company field. Copy the headings and detail lines of the filtered report, and paste it into a new Word document. Save the document as Supplies in the location where you are storing your files. Close Word, save your changes to the Access report, and then close it.
4. Create a query that displays the Company and Category fields from the tblSupplier table and the ProductName, Price, and Units fields from the tblProduct table. Sort in ascending order by the first three fields in the query, and then save the query as qrySupplierProducts.
5. Create a custom report based on the qrySupplierProducts query. Figure 7-38 shows a sample of the completed report. Refer to the figure as you create the report. Distribute the fields horizontally to produce a visually balanced report.
a. Save the report as rptProductsAvailable.
b. Use the Category field (from the tblSupplier table) as a grouping field, and use the Company field (from the tblSupplier table) as a sort field.
c. Hide duplicate values for the Company field.
d. Keep the whole group together on one page.
e. Remove the borders from the field value box.
f. Remove the alternate row color from the group header and detail line.
g. Add a Page title Products Available using 18-point font, centered horizontally.
h. Apply a text filter for companies that contain "Supplies" in the Company Name.
6. Create a mailing label report according to the following instructions:
a. Use the tblSupplier table as the record source.
b. Use Avery C2160 labels, and use the default font, size, weight, and color.
c. For the prototype label, add the ContactFirst, a space, and ContactLast on the first line; the Company on the second line; the Address on the third line; and the City, a comma and a space, State, a space, and Zip on the fourth line.
d. Sort by Zip and then by Company, and then name the report rptCompanyMailingLabels.
e. Format the report with a three-column, across, then down page layout.
7. Make a backup copy of the database, compact and repair, and then close the Supplier database.
Attachment:- Assignment Files.rar