REQUIRED:
a. "Search" the database for all customers with a ZIP code of ZZZZZ (choose a code that is common to at least two, but not to all, of your customers). Obtain a printout of your search algorithm and a list of customers whose records met the search parameter.
b. "Sort" the database in the descending order of credit limit amounts. Obtain both a printout of your sort algorithm and the sorted list of customers.
c. Create a "Customer Status Report" (the report title). Observe the following specific requirements:
(1) Provide column headings, in left-to-right order, for customer name, credit limit, accounts receivable balance, and open orders.
(2) For each state, print subtotals of the accounts receivable balance and open orders columns.