Open the Thrift database you worked with in the previous three modules.

2. Open the tblDonation table datasheet, use an AutoFilter to filter records using the Description field for values of New computer and New television, and then save and close the table.
3. Use Filter By Form with the frmPatronDonations form to select all iecords in which the Patron ID is 3022 or 3035 and the Description is Cash donation. Apply the filter, save the filter as a query named qryPatronDescFilter, and then close the form.
4. Create a query named qryPatronOverJ 00Subquery that selects all PatronlDs from the tblDonation table where the DonationValue Is greater than 100. Use SQL view to create a query named qryPatronNameOverJ 00 that contains all fields from the tblPatron table for records whose PatronlD is in the subquery qryPatronover100Subquery. Save and close the query.

S. Add a multivalued field to the end of the tblPatron table, defining donation values of Donor and Volunteer, and naming the field DonorType with a Caption property value of Donor Type. Save the table, and then add the following values to the field in the table datasheet: for record 2Donor; for record 3Volunteer; for record 4Donor and Volunteer; and for record S Volunteer. Resize the Donor Type column to its best fit, and then save and close the table.

6. Create a query named qryDonorValue that displays all fields from the tblPatron table; for the DonorType field, display only the version of the field that uses the Value property, and change its Caption property setting to Donor Type. Resize the Donor Type column to its best fit in the datasheet, and then save and close the queiy.
7. Add an Attachment field named ReceiptFiles to the end of the tblDonation table, using a Caption property setting of Receipt Files. Attach the document named Receipt2J 00.xIsx to record 1 and Receipt2 J 0J.xlsx to record 2 in the ReceiptFiles field in the tblDonation table, and then close the table.
8. Add an AutoNumber field named DonationNum to the top of the tblSpecialDonation table, using a Caption property setting of Donation Num and a New Values property setting of Increment. Specify the DonationNum field as the primary key. Resize the Donation Num column to its best fit in the datasheet, and then save and close the table.
9. Use the Performance Analyzer to analyze the entire Thrift database, but do not implement any of the analysis results. How many analysis results of the Recommendation type did the Performance Analyzei find? Of the Suggestion type? Of the Idea type? If requested, record the answers in a Word document, and submit it to your instructor. Close the Performance Analyzer dialog box.
10. Use Windows File Explorer to move the StudentVolunteers database from the Access3 > Case3 folder to the Access3 folder. Link to the tblStudentVolunteers table in the StudentVolunteers database located in the Access3 folder. Use Windows File Explorer to move the StudentVolunteers database

to the Access3 > Case3 folder, and then use the Linked Table Manager to refresh the link to the tblStudentVolunteers table.