BCA $120$ Introduction to Computer Applications

Access Homework

Redwood Zoo Michael Rosenfeld wants to find specific information about the

donors and their pledge amounts for the Redwood Zoo You$$ll help him find the

information in the Redwood database by completing the following:

$1.$ Open the Redwood database.

$2.$ Create a query that displays Last Name, First Name, DonorID and Class

$($from the Donor table$).$ Sort the query in ascending order by Last Name.

Save the query as DonorNames.

$3.$ Create a query that, for all pledges with a TotalPledged field value of

greater than $200,$ displays for the DonorID, First Name, Last Name $($from

the Donor table$),$ PledgeID, TotalPledged $($from the Pledge table$),$ and

FundName $($from the Fund table$)$ fields. Sort the query in ascending order

by TotalPledges. Save the query as LargePledges.

$4.$ Create a select query that, for all donors who pledged less than $$150$ or who

donated to the Whale Watchers fund, displays the PledgeID, PledgeDate,

TotalPledge, First Name, and Last Name fields. Save the query as

PledgedOrWhaleWatchers.

$5.$ Create a select query that, for all donors who pledged less than $$150$ and

who donated to the Whale Watchers fund, displays the PledgeID,

PledgeDate, TotalPledge, First Name, and Last Name fields. Save the query

as PledgedAndWhaleWatchers.

$6.$ Create a select query that displays the DonorID $($from The Donor table$),$

TotalPledged, PaymentMethod, Pledgedate, and FundName fields. Save the

query as PLedgesAfterCosts.

BCA $120$ Introduction to Computer Applications

Access Homework

a$.$ Create a calculated field named Overhead that displays the results of

multiplying the TotalPledged field values by $15\%($to account for

overhead cost$).$ Save the query.

$7.$ Create a select query that uses the Pledge table to display the sum, average,

and count of the TotalPledged fields for all pledges. Then do the following:

a$.$ Specify column names of Total Pledge, Average Pledge, and Number

Pledges.

b$.$ Change the properties so that the values in the Total Pledge and

Average Pledge columns display two decimal places and the Fixed

format.

c$.$ Save the query as PledgeStatistics, run the query, resize all

datasheet columns to their best fit, and save the query.

$8.$ Create a select query that uses the Pledge table to display the sum, average,

and count of the TotalPledged fields for all pledges. Then do the following:

a$.$ Specify column names of Total Pledge, Average Pledge, and Number

Pledges.

b$.$ Change the properties so that the values in the Total Pledge and

Average Pledge columns display two decimal places and the Fixed

format.

c$.$ Change the query to display the sum, average, and count of the Total

Pledged field for all pledges by FundName. Save the query as

PledgeStatisticsByFund.

$9.$ Create a query to display all fields from the Donor table. Add a parameter

to select the Donor table records based on the the Last Name field value

that the user specifies. Save the query as LastName.

When you have completed your queries, close the database, please

make sure you upload it$.$ No Printing is required.