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.

Instruction Files

Related Questions in computer science category