Create a customer status report

Assignment Help Database Management System

Reference no: EM131356947

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.

Reference no: EM131356947

Questions Cloud

The sustainable growth rate for the company : Coheed, Inc., had equity of $160,000 at the beginning of the year. At the end of the year, the company had total assets of $224,000. During the year the company sold no new equity. Net income for the year was $72,000 and dividends were $46,080. The s..

A firm credit policy consists of which of the items : A firm's credit policy consists of which of the following items?

What were the problems with the julius calendar : Julius Caesar left a lasting impression on Roman culture that has, in turn, filtered down to the present day. One of the many practical problems he attempted to resolve was the antiquated Roman calendar. This essay involves researching the Julian ..

Example of flexibility option : Which one of the following is an example of a "flexibility" option?

Create a customer status report : "Search" the database for all customers with a ZIP code of ZZZZZ.- Obtain a printout of your search algorithm and a list of customers whose records met the search parameter.

Waiting would probably reduce the project risk : Whether to invest in a project today or to postpone the decision until next year is a decision facing the CEO of the Aaron Co. The project has a positive expected NPV, but its cash flows could be less than expected, in which case the NPV could be neg..

Write a program to enter customer order amounts into system : Write a "program" to enter customer order amounts into the system and to have the system either warn the user if the new order places the customer over his or her credit limit or advise the user if the credit limit is not exceeded.

Project will produce cash inflows : A project will produce cash inflows of €1,750 a year for four years. The project initially costs €10,600 to get started. In year five, the project will be closed and as a result should produce a cash inflow of €8,500. What is the net present value of..

Evaluate key changes in selected companys management style : Evaluate two key changes in the selected company's management style from the company's inception to the current day. Indicate whether or not you believe the company is properly managed today. Provide support for your position.

User Account

All Pages