BIS 345 Quiz 1 For more course tutorials visit www . tutorialrank . com
38 . ( TCO 6 ) Evaluate the Supplier List report below . Management requested this report so they can monitor the value and quantity of the stock on hand ; a requirement of the report is to be able to match the product to the supplier .
Part 1 : Describe at least two enhancements that would make this report more readable to the user .
Part 1 : The two enhancements I would make would be :
Part 2 : Describe at least two features you would include that would add functionality to the report and improve its flexibility for the user . ( Points : 25 )
Part 2 : If I had to include two features to add functionality to the report and improve its flexibility they would be :
===============================================
BIS 345 Quiz 1 For more course tutorials visit www . tutorialrank . com
1 . ( TCO 2 ) Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations 2 . ( TCO 2 ) Which of the following functions would you use to extract characters from the middle of a string . 3 . ( TCO 2 ) Which date function will return the difference between two dates in the specified units ? 4 . ( TCO 3 ) If you wanted to know the highest credit line in your customer database , which if the following functions would you use in your SQL . 5 . ( TCO 3 ) Which of the following clauses filters groups 6 . ( TCO 3 ) Which of the following characters can be used with the COUNT function to return the total numbers of rows in the query