Design or modify the OUTSTANDING COMPUTER PURCHASE ORDERS REPORT. Refer to the repository entry for the data flow for the elements. This report would be produced for all PURCHASE ORDER records that have a purchase order code of M101, representing computers, with the additional condition that the QUANTITY ORDERED on the record must be greater than the QUANTITY RECEIVED. In a paragraph, state whether this report is a summary, exception, or detailed report. Explain.

What will be an ideal response?






This is an exception report. The report is produced by selecting a subset of records from the Purchase Order file. The first selection criteria is that records must be in the Computer category (the purchase order code is M01), and the second is that the records must represent outstanding purchase orders (the quantity received is less than the quantity ordered).

Computer Science & Information Technology

You might also like to view...

Table 9.1 lists the two nearest neighbors of four points.

Computer Science & Information Technology

Which one of the following is true about arguments and parameters?

(A) Arguments appear in calling statements; parameters appear in Sub statements. (B) Parameters appear in calling statements; arguments appear in Sub statements. (C) They are synonymous terms. (D) They are completely unrelated in a program.

Computer Science & Information Technology

What is the purpose of the task list?

What will be an ideal response?

Computer Science & Information Technology

Which of the following is a malware program designed to replicate without attaching to or infecting other files on a host system?

What will be an ideal response?

Computer Science & Information Technology