Upload Complete Jork Assignment on your Computer Assignment Instructions 7 8 Create a query in Query Design view based on both tables to answer the questions, Which Paper Names were published with a Publisher Name that has Texas as part of its name, what is the Contact Name and Contact Phone Number, and what was the Award Paid, sorted in descending order by the Award Paid field? (Hint: Use a wildcard character in the criteria row.). Run the query (eight records display). Save the query as 2F Texas Publishers Query, and then close the query. Create a query in Query Design view based on the 2F Student Papers table to answer the question, In ascending order by the Paper ID field, what will be the Federation Donation to the Writing Lab if the Federation donates additional 50 (.5) percent of each award paid to students? Run the query (the first record-Paper ID P-01has a Federation Donation of 20). Display the query in Design view. In the fourth column of the design grid, create a new field named Total Donation that will answer the question, What is the total value of each scholarship after the alumni association donates an additional 50%? Run the query (the first record-Paper ID P-01has a Total Donation of S60.00). Close Upload Complete Jork Assignment on your Computer Assignment Instructions 7 8 Create a query in Query Design view based on both tables to answer the questions, Which Paper Names were published with a Publisher Name that has Texas as part of its name, what is the Contact Name and Contact Phone Number, and what was the Award Paid, sorted in descending order by the Award Paid field? (Hint: Use a wildcard character in the criteria row.). Run the query (eight records display). Save the query as 2F Texas Publishers Query, and then close the query. Create a query in Query Design view based on the 2F Student Papers table to answer the question, In ascending order by the Paper ID field, what will be the Federation Donation to the Writing Lab if the Federation donates additional 50 (.5) percent of each award paid to students? Run the query (the first record-Paper ID P-01has a Federation Donation of 20). Display the query in Design view. In the fourth column of the design grid, create a new field named Total Donation that will answer the question, What is the total value of each scholarship after the alumni association donates an additional 50%? Run the query (the first record-Paper ID P-01has a Total Donation of S60.00). Close