Over the course of this class, you have been building a database to track and calculate your final grade. For this exercise, you will use this database to complete a series of tasks and submit your work. Please adhere to the following submission guidelines and instructions:

Submission Guidelines:

Submit a single Microsoft Access file containing your database.

Submit one PDF file containing your responses to the tasks below. Multiple files will not be accepted.

Tasks:

$1.$ Final Grade Calculation Query:

Write and run an SQL query to calculate your current final grade out of $100.$

The query should display the count and average score of each deliverable type, and your overall final grade.

Submit the SQL code and screenshots of the query results.

$2.$ Minimum Grade Analysis:

Input data for all course deliverables, using $\text{'}0\text{'}$ for grades not yet received.

Run a query to determine the minimum possible final grade you can achieve.

Submit the SQL code and a screenshot of the result.

$3.$ Maximum Grade Analysis:

Fill in all deliverable data, inputting the maximum possible scores for grades not yet received.

Run a query to calculate the maximum possible final grade.

Submit the SQL code and a screenshot of the result.

$4.$ Macro Development:

Develop either a stand alone or a data $/$ embedded macro for the database $($one macro!$).$

Include a screenshot of the macro designer and its outcome.

Provide an explanation of the macro's purpose and functionality.

$5.$ Bonus $(25$ points$)-$ Letter Grade Calculation Queries:

Create a new table in your database for letter grades as per the course syllabus.

Include a screenshot of this table.

Develop and run queries to calculate your letter grade for both the minimum and maximum grades.

Submit the SQL codes and screenshots of the outcomes.