Page 501 - Computer Software Application TP - Volume 1
P. 501
COMPUTER SOFTWARE APPLICATION - CITS
This code assumes that you have a table named “Table13_2” in your workbook with columns named “Principal
Amount” and “Interest.” The result is a new table (CombinedQuery) that includes the original columns from
“Table13_2” and an additional column named “Sum” containing the sum of the “Principal Amount” and “Interest”
values for each row.
TASK 3 :
Create a table named “OrderDetails” containing columns for “Product”, “Quantity”, and “UnitPrice”. Apply a 10%
discount to the “UnitPrice” for orders where the quantity purchased is greater than or equal to 10.
Order Details
Product Quantity Unit Price
Product A 8 20.00
Product B 15 30.00
Product C 5 10.00
Product D 12 25.00
Product E 20 15.00
Product F 9 18.00
Product G 7 22.00
Product H 14 28.00
Product I 6 12.00
Product J 11 35.00
486
CITS : IT & ITES - Computer Software Application - Exercise 76
