Case Problem -

Diane's Community Center - Diane Coleman asks you to create a custom report for the Community database so that she can better track donations made by donors and to create mailing labels.

Complete the following steps:

1. Open the Community database you worked with in the previous two modules.

2. Create a query that displays the Description, DonationDate, and DonationValue fields from the tblDonation table, and the FirstName and LastName fields from the tblPatron table. Sort in ascending order by the Description, DonationDate, and LastName fields, and then save the query as qryPatronDonations.

3. Create a custom report based on the qryPatronDonations query. Figure 7-42 shows a sample of the first page of completed report. Refer to the figure as =you create the report.

a. Save the report as rptPatronDonations.

b. Use the Description field as a grouping field.

c. Select the DonationDate field as a sort field and the LastName field as a secondary sort field.

d. Hide duplicate values for the DonationDate field.

e. Use black font for all the controls.

f. Keep the whole group together on one page.

g. Use Wide margins, and set the grid width to 6 inches. Size fields as shown, and distribute horizontally, using spacing to create a balanced look.

h. Create a conditional formatting rule for the DonationValue field to display the value in blue, bold font when the amount is more than $200.

i. Make any additional changes to the layout and formatting of the report that are necessary for it to match Figure 7-42. Also include a grand total of all donations at the end of the report.

4. After you've created and saved the rptPatronDonations report, filter the report in Report view, selecting all records that contain "Jo" in the LastName field. Copy the entire filtered report, and paste it into a new Word document. Save the document as PatronJo in the location where you are storing your files. Close Word, and then save and close the Access report.

5. Diane's Community Center is having a fundraiser dinner, and Diane would like name tags for the patrons. Use the following instructions to create mailing labels that will be used as name tags:

a. Use the tblPatron table as the record source for the mailing labels.

b. Use Avery C2160 labels, and use a font size of 16, with Normal weight and black color.

c. For the prototype label, place FirstName, a space, and LastName on the first line.

d. Sort by LastName, and then type the report name rptPatronNameTags.

e. Change the page layout of the rptPatronNameTags report to three snaking columns.

6. Make a backup copy of the database, compact and repair it, and then close it.

Attachment:- Assignment Files.rar