Run Access. Open the Apply Friendly Janitorial Services database that you modified in Apply Your Knowledge In Module
computer science
Description
Instructions: Run Access. Open the Apply Friendly Janitorial Services database that you modified in Apply Your Knowledge In Module 1. (If you did not complete the exercise, see you; instructor for a copy of the modified database.)
Perform the following tasks:
Create a query for the Client table and add the Client Number, Client Name, Amount Paid,
and Current Due fields tohe design grid. Add a criterion to find all clients whose names start
with the letter B. Run the query an then save It as Apply 2 Step I Query.
Create a query for the Client table and add the Client Number, Client Name, Amount Paid,
and Supervisor Number fields to the design grid. 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. Save the query ciS Apply :2 Step 2 Query.
