BIS 345 mentor Career Begins/bis 345mart.com BIS 345 mentor Career Begins/bis 345mart.com | Page 24

2.( TCO 6) Which of the data source credential options is the least recommended because of security risks 3.( TCO 5) All of the following are types of query for a data set except ________. 4.( TCO 6) _____ regions are items that must be associated with a data set. 5.( TCO 6) Data regions support grouping and ______. 6.( TCO 6) _____ is the simplest report item and contains no data values 7.( TCO 7) ______ presents group data in a grid layout that ' s capable of expanding both rows and columns 8.( TCO 5) Of the following four Tablix internal areas, which is a required area? 9.( TCO 7) The chart _____ contains the plotting area of a chart 10.( TCO 7) A ________ report item is a great tool to graphically display key performance indicators =========================================================
BIS 345 Week 1 iLab

FOR MORE CLASSES VISIT www. bis345mentor. com

Student Name: Name Using Lab 1, answer the questions and provide copies of your SQL Statements and / or results for each Section listed below Part A: Customer List( 4 points) a. What does the ORDER BY clause do? b. Screen print your results and paste here: Part B: Customer List with only customers In France or Germany( 4 points)
Part C: Using a Calculation in a Query( 5 points) Part D: Products that are discontinued( 5 points) Part E: Practice using the BETWEEN operator( 5 points)