This is a very easy task. Please send the file link when finished.

Add the following records to the Houses table House Address Project Manager Start End Budge ID Date Date t H105 2897 Elm Street Scott 05/18/16 09/01/16 50000 H106 5206 Franklin Ave. Walton 04/01/16 08/01/16 35000 H107 5207 Franklin Ave. Walton 04/01/16 08/15/16 42000 H108 5208 Franklin Ave. Walton 04/30/16 09/15/16 33000 H109 5209 Franklin Ave. Walton 04/30/16 09/30/16 27000 H104 1466 Elm Street Scott 04/30/16 09/15/16 35000 H102 1588 Elm Street Scott 04/15/16 09/30/16 25000 H101 1589 Elm Street Scott 05/01/16 08/15/16 16000 H120 901 Chester Ave. Henderson 05/01/16 08/15/16 45000 H121 902 Chester Ave. Henderson 05/01/16 08/15/16 37000 6) Add the following records to the Volunteers table (it will be easy if you completed instruction 4 correctly). Volunteer ID Last Name First Name Phone House ID VO197 Mitchell Bill 416-890-7856 H107 VO198 Carpenter Candy 905-907-8967 H120 VO199 Bell Don 416-890-8744 H120 VO200 Reynolds Sarah 416-890-5633 H101 VO201 Brooks Hannah 416-890-7822 H121 VO202 Brooks Austin 416-890-7822 H121 VO203 Miller Philip 905-997-5645 H104 VO204 Lang Tamara 905-997-3321 H107 VO205 Mulloy. Tim 905-997-0009 H109 VO206 Smith Pam 416-897-1234 H101Scope When you volunteered to work with a local Charity, you were assigned to maintain a database pertaining to current projects. The Charity re-builds houses for families who cannot afford to buy a house for themselves. Each house is assigned a House lD which is unique to that house. As people from the community volunteer, they are assigned to one of the house projects. It is yourjob to keep up with this data pertaining to house projects and their assigned volunteers. This is a new database that you must create and then begin accumulating the data. 1) Start Access and open a new Blank desktop database named XXXXX xxxxx Project 3.accdb, replacing XXXXX (Oday) with your last name, and replacing xxxxx (Morris) with your first name. 7) 3) 9) Create a Query which satises the following needs: a) In this order, display the Project Manager, Address, Start Date, and End Date fields from the Houses table. b) In order, add the elds Last Name, First Name, and Telephone Number from the Volunteers table to the query. You should now have seven fields in your query. 0) Select only those rows where the End Date falls within August, 2016. d) Sort the query data by Start Date. e) Save the query as Contact List. 1) Modify the query to select only those rows where the Start Date falls within August 2016. Hint: You don't have to have data showing for the query to be correct. g) Save the query asVacatIon Schedule. Create a query that displays Total Budget for each Project Manager from the Houses Table a) Save Query as Total Budget Create another query which: a) Displays the Project Manager, Address, Start Date, and End Date fields from the Houses table. b) Sort by the Start Date. c) Also displays a fifth column of data, the total number of volunteers that have been assigned to the house. There's a hint in that sentence, if you look carefully. d) The default name of the fth column is not that attractive. Find a way of renaming it to Number of Volunteers. Hint: think of how you name a calculated field. e) Save the query as Staffing Levels. 10) Save and close your le. 2) Createatable, Houses, that contains the following fields: Field Name Data Description Type House ID Short Text Uniquely identifies the house project and is the primary key Project Short Text 15 Project Manager Name Manager Start Date Date/Time Default Short Date Date the project was started End Date Date/Time Default Short Date Estimated completion date Budget Estimated Project budget places Page break Create a second table, Volunteers, that contains the following fields. Volunteer ID Short Text Uniquely identifies the volunteer and is the Primary Key Short Text Volunteer's Last Name Short Text Volunteer's First Name Short Text Volunteer's Phone Number