Create a query for the Client table and add the Client Number, Client Name,

Amount Paid, and Current Due fields to the design grid in that order. Add a

criterion to find all clients whose names start with the letters$$HU$.$ Run the

query and then save it as$$Step $3$ Query.

$4.$ Open the Step $4$ Query in design view in the navigation pane. Sort the records

in descending order by Amount Paid. Add a criterion for the Supervisor Number

field that allows the user to enter a different supervisor each time the query is

run. Run the query and enter$114$as the supervisor number to test the query.

Run the query and then save it$.$

$5.$ Open the Step $5$ Query in design view in the navigation pane. Add a criterion to

find all clients whose current due amount is greater than or equal to $$3500\mathrm{.}00$

or equal to $$0\mathrm{.}00.$ Run the query and then save it$.$

$6.$ Open the Step $6$ Query. Sort the records in ascending order by Client Number

within Supervisor Number. Edit the join properties of this query to show all

records from the Supervisor Table and only those records from the Client Table

where the joined fields are equal. Run the query and save it$.$

$7.$ Open the Step $7$ Query. To the right of the Current Due field, create a

calculated field named$$Total$$that sums the Current Due and Amount Paid

Fields. Run the query and then save it$.$

$8.$ In the supervisor table, replace supervisor $110\text{'}$s last name and first name with

your last name and first name.