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