The National Foundation for Animals was founded on March 23, 2014 as is a nonpro?t organization that ?nds homes for abandoned animals that are suitable for adoption. NFA began operations with a bequest from a wealthy woman who lived her life taking care of stray cats and wanted to be sure that such animals were looked after once she was gone. Although the amount the foundation started with was suf?cient to set up an of?ce and begin operations, it depends upon continuing donations to run daily operations. NFA has relied on 6 contributors in the past but has just been contacted by 5 more individuals wanting to donate. Usually, donations are given with a particular type of animal in mindfor example, for dogs. Now that the number of contributors has grown, the Board has decided to move away from the file system the foundation has been using and develop a database to handle the foundations accounting and reporting needs.

NOTE: YOU MUST USE 2016 ACCESS. IF YOU DO NOT HAVE THIS PROGRAM YOU CAN FIND IT ON THE FSU VIRTUAL OFFICE RDS OR CITRIX. YOU CAN ALSO USE THE COMPUTER LABS AT SBE. YOUR DATABASE MUST BE SAVED USING THE FOLLOWING FORMAT:

LastnameFirstnameinitialNFA for example BibleLNFA (HINT: Use the Blank Desktop Database template)

Using 2016 Access create a database using the information in the NFA files. You should have separate tables for contributors (create phone numbers for each contributor), donations, and whether the donations are to be used for dogs, cats, or unspecified. (Hint: use Table Design)

Add yourself and 4 other individuals as contributors.

Add at least one donation for each of the 5 new contributors (donated between December 26 31, 2014).

Create relationships for the tables. (be sure to save your relationships)

Create a query that selects all customers donating to cats.

Create a query that selects all contributors who donated over $50.

Create a query that selects all contributors who donated over $100 to dogs.

Create a query that calculates total donations by contributor for the year.

Create a report that contains a current list of contributors. The report should include the following information in the header: Foundations Title, a graphic of one of the animals accepted by NFA, your name as the developer, and the date you created the report. The body of the report should contain the name, address, and phone number of all contributors, listed alphabetically by contributors last name. The information for each contributor should all be on one line. Name the report Contributors Report.

Create a report that contains a complete list of all contributors who gave donations during the months of November and December 2014. The report should include the following information in the header: Foundations Title, a graphic of one of the animals accepted by NFA, your name as the developer, and the date you created the report. The body of the report should list donations in order of the donators last name and should include the donators address and phone number. Name the report November and December 2014 Donations.

NFA Contributor File

Contributor ID	Last Name	First Name	Street Address	City	State	Zip
10000	Burgman	Sarah	14107 Pine Ridge	Reno	NV	48733
10001	Aggies	Gordon	1845 Mays Ave	College Station	TX	77843
10002	Lawrence	Marie	9190 Bentley Rd	Waltham	MA	02423
10003	Kitty	Robert	5815 AIS Lane	Tampa	FL	53887
10004	Fox	Thomas	218 Middle Rd	Fayetteville	NC	28306
10005	Hyde	Angela	27 King Rd	Conway	AR	66245

NFA Donation File

Donation Date	Animal Code	Amount	Contributor ID
March 23, 2014	U	$100,000	10000
May 12, 2014	U	25	10001
June 22, 2014	U	500	10002
September 20, 2014	D	200	10001
October 18, 2014	U	20	10003
November 10, 2014	C	500	10004
November 11, 2014	C	150	10002
November 15, 2014	D	250	10005
December 09, 2014	C	100	10004
December 10, 2014	C	250	10002
December 14, 2014	D	100	10001
December 14, 2014	C	100	10003
December 21, 2014	U	35	10005

NFA Animal Code Table

Contribution for:	Code
Dogs	D
Cats	C
Unspecified	U