this is ACCESS work i need you to PROVIDE what id put in queries to get the answers at the bottom of the screen. PLEASE be clear will leave good review

CS&E 2111 IN LAB 9 Download from Simnet: CSE 2111 In Lab 9 Sorority Volunteers Master.accdb PART 1: CSE 2111 IN LAB 9 SORORITY VOLUNTEERS MASTER DATABASE The Sigma sorority members at Grand State University in Colorado pride themselves on volunteerism. Over the past 10 years, they have been voted the most philanthropic of all organizations at the school. Every semester (excluding Summer) each woman in the sorority makes a pledge to spend time working in a volunteer activity based on their schedules and commitments. The sorority sisters almost see volunteerism as a competition because the sorority member with the most service hours at the end of the year gets to take the sorority's pink convertible car home for the summer! In the past, the sorority has had some problems recording volunteer hours. For example, some sorority sisters have claimed that not all their hours were written down. Therefore, one sorority member has taken matters into her own hands. After attending an information systems class, she has designed a database to keep track of volunteer hours. You are hired to finish the database project, and you begin the job with the tables already designed for you. The database contains five tables: Members: Lists member information such as ID, name, e-mail address, and telephone number. Each member is identified by a unique Member 10. Charities: Keeps track of all the charities in which the sorority sisters participate in particular, the table includes charity IDs and names, the contact person at each charity, address, phone number, and e-mail address. Each charity is identified by a unique Charity ID. Events: Lists the different charitable events around town. This table includes information about each event, the date, and when the event begins. Each event is identified by a unique Event ID. Volunteer Hours: Lists the sorority sisters' hours spent volunteering at specific events. Each record in this table is uniquely identified by a combination of fields: Member ID and Eventid. Pledged Hours: Lists the sorority sisters' hours pledged each semester. Each record in this table is uniquely identified by a combination of fields: Member ID and Semester Pledged. PART 1: SETTING UP THE DATABASE Set the primary keys, relationships, enforce referential integrity, cascade update, and cascade delete. The database has already been populated. IMPORTANT NOTE Notice the Pledged Hours and volunteer Hours tables both have two fields that make up the primary key. This is called a composite or concatenated key and is used when a combination of fields is needed to make each record unique. To create a composite key select both fields, and then click the Primary key icon. 9 PART 2: QUERIES Complete the following queries based on the CSE 2111 In Lab 9 Sorority Volunteers Master database. Name your queries by the problem number and if more than one query is needed as A, B etc. (Query 1A, Query 18, Query 1C etc.) Query 1: The women's club is willing to donate $5 to women's charities for every hour spent volunteering Write aquery that calculates the extra money donated to female charities. (Note: Female charities will always begin with the words, "Women", or "Girls") List the Charity Name, first and last name of the contact person, the Charity phone number, the Charity Email, the hours volunteered, and the money donated (format money donated field to currency). Query 2: The "Save the Mountains" Charity and The Girls Club" Charity would like to schedule a few more events on or after October 10, 2021. Write a query that displays all of the events these charities have scheduled on or after October 10, 2021. List the Charity Name, the Event, and the date of the Event. Sort the list by Charity (ascending) and Event Date (ascending). Query 3: The Spring semester is coming to an end and your sorority sisters would like to find out how many hours they still need to volunteer, based on the hours they have pledged for the year. Write a query that calculates the remaining hours each member needs to volunteer in order to fulfill their commitment. List the member's first name, last name, hours pledged, hours volunteered, and the remaining volunteer hours. (Make sure to include all members regardless of whether or not they have made a pledge or volunteered.) Use the Nz function to display a "o" for the Null values in the Remaining Volunteer Hours column. See Screenshots below to guide you through the queries Query 1 - yume Contact Dont Query 2- Query 2 Charity Name. Event Name Girls' Club Dog Agility Girls' Club Pet Photos Save the Mountains Map the Mountains Date 10/12/2021 12/1/2021 1/10/2022 105 Query 3A - Gery Member ID - First Name . Last Name Sumonoun 101 Quinn O'Hara 102 Maria Sanchez SO 103 Angela Borg 104 Preeti Amith 15 Ann Jones SO 106 Juliet Wanauski 40 107 Katie Watson 308 joan Zeff 20 109 Linda Bounder 110 Marlene Finkel 40 Query 3B - Query 38 Member D. SumofHours 203 102 6 203 104 11 105 6 106 207 108 9 109 110 Query 30 - Query ac First Name . Last Name - Query 3A Sur . Query 3. SumOf Hours. Quinn O'Hara Maria Sanchez Angela Borg Preet Amith 15 11 Ann Jones SO 6 Juliet Wanauski 40 Katie Watson Joan Zeff 20 Linda Bounder 9 Marlene Finkel 40 7 Lab 9 submissions 1. CSE 2111 In Lab 9 Sorority Volunteers Master.accdb 85mm Remaining Hours 40 44 0 4 44 40 WOSA 11 -9 33 CS&E 2111 IN LAB 9 Download from Simnet: CSE 2111 In Lab 9 Sorority Volunteers Master.accdb PART 1: CSE 2111 IN LAB 9 SORORITY VOLUNTEERS MASTER DATABASE The Sigma sorority members at Grand State University in Colorado pride themselves on volunteerism. Over the past 10 years, they have been voted the most philanthropic of all organizations at the school. Every semester (excluding Summer) each woman in the sorority makes a pledge to spend time working in a volunteer activity based on their schedules and commitments. The sorority sisters almost see volunteerism as a competition because the sorority member with the most service hours at the end of the year gets to take the sorority's pink convertible car home for the summer! In the past, the sorority has had some problems recording volunteer hours. For example, some sorority sisters have claimed that not all their hours were written down. Therefore, one sorority member has taken matters into her own hands. After attending an information systems class, she has designed a database to keep track of volunteer hours. You are hired to finish the database project, and you begin the job with the tables already designed for you. The database contains five tables: Members: Lists member information such as ID, name, e-mail address, and telephone number. Each member is identified by a unique Member 10. Charities: Keeps track of all the charities in which the sorority sisters participate in particular, the table includes charity IDs and names, the contact person at each charity, address, phone number, and e-mail address. Each charity is identified by a unique Charity ID. Events: Lists the different charitable events around town. This table includes information about each event, the date, and when the event begins. Each event is identified by a unique Event ID. Volunteer Hours: Lists the sorority sisters' hours spent volunteering at specific events. Each record in this table is uniquely identified by a combination of fields: Member ID and Eventid. Pledged Hours: Lists the sorority sisters' hours pledged each semester. Each record in this table is uniquely identified by a combination of fields: Member ID and Semester Pledged. PART 1: SETTING UP THE DATABASE Set the primary keys, relationships, enforce referential integrity, cascade update, and cascade delete. The database has already been populated. IMPORTANT NOTE Notice the Pledged Hours and volunteer Hours tables both have two fields that make up the primary key. This is called a composite or concatenated key and is used when a combination of fields is needed to make each record unique. To create a composite key select both fields, and then click the Primary key icon. 9 PART 2: QUERIES Complete the following queries based on the CSE 2111 In Lab 9 Sorority Volunteers Master database. Name your queries by the problem number and if more than one query is needed as A, B etc. (Query 1A, Query 18, Query 1C etc.) Query 1: The women's club is willing to donate $5 to women's charities for every hour spent volunteering Write aquery that calculates the extra money donated to female charities. (Note: Female charities will always begin with the words, "Women", or "Girls") List the Charity Name, first and last name of the contact person, the Charity phone number, the Charity Email, the hours volunteered, and the money donated (format money donated field to currency). Query 2: The "Save the Mountains" Charity and The Girls Club" Charity would like to schedule a few more events on or after October 10, 2021. Write a query that displays all of the events these charities have scheduled on or after October 10, 2021. List the Charity Name, the Event, and the date of the Event. Sort the list by Charity (ascending) and Event Date (ascending). Query 3: The Spring semester is coming to an end and your sorority sisters would like to find out how many hours they still need to volunteer, based on the hours they have pledged for the year. Write a query that calculates the remaining hours each member needs to volunteer in order to fulfill their commitment. List the member's first name, last name, hours pledged, hours volunteered, and the remaining volunteer hours. (Make sure to include all members regardless of whether or not they have made a pledge or volunteered.) Use the Nz function to display a "o" for the Null values in the Remaining Volunteer Hours column. See Screenshots below to guide you through the queries Query 1 - yume Contact Dont Query 2- Query 2 Charity Name. Event Name Girls' Club Dog Agility Girls' Club Pet Photos Save the Mountains Map the Mountains Date 10/12/2021 12/1/2021 1/10/2022 105 Query 3A - Gery Member ID - First Name . Last Name Sumonoun 101 Quinn O'Hara 102 Maria Sanchez SO 103 Angela Borg 104 Preeti Amith 15 Ann Jones SO 106 Juliet Wanauski 40 107 Katie Watson 308 joan Zeff 20 109 Linda Bounder 110 Marlene Finkel 40 Query 3B - Query 38 Member D. SumofHours 203 102 6 203 104 11 105 6 106 207 108 9 109 110 Query 30 - Query ac First Name . Last Name - Query 3A Sur . Query 3. SumOf Hours. Quinn O'Hara Maria Sanchez Angela Borg Preet Amith 15 11 Ann Jones SO 6 Juliet Wanauski 40 Katie Watson Joan Zeff 20 Linda Bounder 9 Marlene Finkel 40 7 Lab 9 submissions 1. CSE 2111 In Lab 9 Sorority Volunteers Master.accdb 85mm Remaining Hours 40 44 0 4 44 40 WOSA 11 -9 33