23 candlewick drive brockport ny

Management Information System And App

Add Sample Data to the Donations Table Add 10 records to the Donations table.

a. Add the following records to the Donations table.

Donation ID Donor ID Plant ID Date Of Donation

Amount Of Donation

10 8228 611 3/1/2015 $150 18 5448 190 3/1/2015 $15

6 4091 457 3/12/2015 $125 7 11976 205 3/14/2015 $100 1 1600 25 3/17/2015 $120

12 1444 38 3/19/2015 $50 2 1444 38 4/3/2015 $50 4 10520 49 4/12/2015 $460 5 3072 102 4/19/2015 $450

21 1204 25 4/22/2012 $120

b. Sort the Donations table by the Amount0fDonation field in descending order.

Use the Query Wizard Use the Query Wizard to create a query of all donations greater than $100 in the Donations table. Use the following guidelines:

a. Include the DonorlD and Amount0fDonation fields.

b. Name the query Donations Over 100.

C. Add criteria to include only donations of more than $100.

d. Sort by ascending Amount0fDonatron.

e. Save and close the query.

Create a Query in Design View You need to create a query that identifies the people who made a donation after April 1, 2015. The query should list the date of the donation, donor's full name (LastName, FirstName). phone number. the amount of the donation, and name of the plant they want. Sort the query by date of donation, then by donor last name. This list will be given to the Arboretum staff so they can notify the donors that a plant is ready for pickup.

a. Click the CREATE tab and click Query Design in the Queries group.

b. Add the tables and fields necessary to produce the query as stated previously. Name the query Plant Pickup List

c. Run and print the query from Datasheet view.

Modify a Query in Design View a. Copy the Plant Pickup List query on the Navigation Pane

and paste it using ENewsletter as the query name.

b. Open the ENewsletter query in Design view and delete the DateofDonation column.

C. Add the ENewsletter field to the design and set it to sort in Ascending order. Position the ENewsletter field on the grid so that the query sorts first by ENewsletter and then by LastName.

d. Compact and repair the database. Close Access.

e. Submit based on your instructor's directions.