Instructions: Perform the following tasks:

Run Access. Open the Lab $1$ Garden Naturally database and create a new query for the Customer table. Add the Customer Number, Customer Name, Amount Paid, Balance Due, and Sales Rep Number fields to the design grid, and restrict the query results to only those customers where the sales rep number is $29.$ Save the query as Lab $2-1$ Step $1$ Query.

Create a query for the Customer table that includes the Customer Number, Customer Name, and Balance Due fields for all customers located in Delaware $($DE$)$ with a balance due greater than $$1,000\mathrm{.}00.$ Save the query as Lab $2-1$ Step $2$ Query.

Create a query for the Customer table that includes the Customer Number, Customer Name, Address, City, and State fields for all customers located in cities that begin with Ch$.$ Save the query as Lab $2-1$ Step $3$ Query.

$4.$ Create a query for the Customer table that lists all states in ascending order. Each state should appear only once. Save the query as Lab $2-1$ Step $"4$ Query.

$5.$Create a query for the Customer table that allows the user to type the name of the desired city when the query is run. The query results should display the Customer Number, Customer Name, Balance Due, and Amount Paid fields in that order. Test the query by searching for those records where the customer is located in Quaker. Save the query as Lab $2-1$ Step $5$ Query.

$6.$Create a query for the Sales Rep table that includes the First Name, Last Name, and Start Date for all sales reps who started after June $1,2015.$ Save the query as Lab $2-1$ Step $6$ Query.

$7.$Create a query that joins the Sales Rep and Customer tables. Include the Sales Rep Number, Last Name, and First Name from the Sales Rep table. Include the Customer Number, Customer Name, and Amount Paid from the Customer table. Sort the records in ascending order by sales rep$$s last name and then by customer name. Save the query as Lab $2-1$ Step $7$ Query.

$8.$Open the Lab $2-1$ Step $7$ Query in Design view and remove the Sales Rep table from the query. Add the Balance Due field to the design grid. Calculate the total of the balance and amount paid amounts. Assign the caption Total Amount to the calculated field. Change the caption for the Amount Paid field to Paid and the caption for the Balance Due field to Owed. Save the query as Lab $2-1$ Step $8$ Query.

$9.$Create a query for the Customer table to display the total amount paid for sales rep $26.$ Save the query as Lab $2-1$ Step $9$ Query.

$10.$ Create a query for the Customer table to display the average balance due for each sales rep. Save the query as Lab $2-1$ Step $10$ Query.

Turn in the assignment in Canvas.