PLease help me with a micrososft access Query design question. Here is the resulting tables $($Student$,$ Registration, and Course$).$ These are the following fields for Student $($StudentID $($Primary Key$)$ FirstName, LastName, Address, City, State, Zip, Phone, BirthDate, and Assessment$).$ These are the fields for the Registration Table $($SignupID $($Primary Key$),$ StudentID, InstanceID, TotalCost, and BalanceDue$).$ These are the fields for Crourse Table $($InstanceID $($Primary Key$),$ Title, StartDate, EndDate, HoursPerWeek, Cost$).$ Here is the problem that I need help with. Open the Career database you created and worked with in previous modules, and then click the Enable Content button next to the security warning, if necessary.

$2.$

In the Student table, find the record for StudentID ART$5210,$ and then change the Street value to $417$ Barclay Avenue and the Zip to $80202.$

$3.$

In the Student table, find the record for StudentID ESP$1734,$ and then delete the record. $($Hint: Delete the related records in the Registration subdatasheet first.$)$ Close the Student table.

$4.$

Create a query that lists students who are on a payment plan for any of the courses offered by Great Giraffe. List only the StudentID, FirstName, and LastName fields for the students in your results, and sort the results in ascending order by the LastName field. Save the query as AllPaymentPlanStudents, run the query, and then close it$.$

$5.$

In the Navigation Pane, copy the AllPaymentPlanStudents query, and then rename the copied query as LittletonPaymentPlanStudents.

$6.$

Modify the LittletonPaymentPlanStudents query so that it only displays those students from the city of Littleton. $($Hint: When you are entering the criteria for a Short Text field, Access usually places the quotation marks around the text; however, you may also type the quotation marks if you are having trouble entering the text properly.$)$ The City field should not appear in the query datasheet. Save and run the query, and then close it$.$

$7.$

Create a query that lists students who are taking one of the Computer Science courses offered. $($Hint: Instead of looking at the individual sections, look at the Title of the courses.$)$ In the query results, display only the StudentID, FirstName, LastName, and Phone of the students in the courses. Sort the results by StudentID in ascending order. Save the query as CompSciStudents and run the query.

$8.$

Use the CompSciStudents query datasheet to update the Student table by using $(303)555-0042$ for the Phone value for Wendy Bradshaw.

$9.$

Change the size of the text in the CompSciStudents query datasheet to use a $14-$point font size. Resize columns, as necessary, so that all field values and column headings are visible.

$10.$

Change the alternate row color in the CompSciStudents query datasheet to the Theme Color named Green, Accent $6,$ Lighter $80\%,$ and then save and close the query.

$11.$

Create a query that lists the InstanceID, Title, StartDate, HoursPerWeek, and Cost fields for courses that begin anytime in the first three months of $2021.$ Save the query as FirstQuarterClassOptions, run the query, and then close it$.$

$12.$

Create a query that lists the total outstanding balances for students on a payment plan and for those students that are not on a payment plan. Show in the query results only the sum of the balance due, grouped by PaymentPlan. Name the summation column Balances. Run the query, resize all columns in the datasheet to their best fit, save the query as TotalBalancesByPlan, and then close it$.$

$13.$

Compact and repair the Career database, and then close it$.$