$2-20.$ ACCESS APPLICATION: Telethon Call Reports

The volunteer coordinator of the Downtown Emergency Shelter has asked you to use the information provided in Figure $2\mathrm{.}22$ to create an Access database. $($You can download the Excel file called Ch$02$Ex$02$ and import the data into your database.$)$ The coordinator will use the database to manage donor records and help the shelter prepare for an upcoming Phonathon fund$-$raising event. During the Phonathon, volunteers will call previous donors to ask for donations to this year$$s fund. Your instructions are to create two tables $($donors and volunteers$)$ and prepare a Phonathon Call Report for each volunteer. The shelter manager wants you to add three fields to the donor table: this year$$s contribution, a calculated field that shows the average contribution per employee, and a calculated field that shows a target contribution that is $5$ percent higher than last year$$s contribution. The report should list the volunteer$$s name and number as well as the following donor information: donor number, donor name, company name, phone number, contribution amount from the prior year, number of employees, average contribution per employee, and target contribution for this year. Although address information will not be included on the report, that information will be used to send receipts to the donors at the conclusion of this year$$s fund$-$raising event.