Using Wildcards in a Query, Creating a Parameter Query, Joining Tables, and Creating a Report Perform the following tasks:

1. Import the Accounting table from the pdf , there is link.

2.Create a query for the Accounting table and add the Client Number, Client Name, Amount Paid, and Advisor fields to the design grid. Sort the records in descending order by Amount Paid. Add a criterion for the Advisor field that allows the user to enter a different advisor each time the query is run. Run the query and enter 114 as the advisor to test the query. Save the query as Apply 2 Step 2 Query.

3.Create a query for the Accounting table and add the Client Number, Client Name, and Current Due fields to the design grid. Add a criterion to find all clients whose current due amount is less than $500. Run the query and then save it as Apply 2 Step 3 Query.

4.Create a query that joins the Advisor and Client tables. Add the Advisor Number, Last Name, and First Name fields from the Advisor table and the Client Number and Client Name fields from the Client table to the design grid. Sort the records in ascending order by Client within Advisor. Run the query and save it as Advisor-Client Query. Note: if any error messages appear, check the field types of the fields in the query tables and make changes as necessary.

5. Create the report shown in the attachment.