BIS 345 MENTOR Invent Yourself/bis345mentor.com BIS 345 MENTOR Invent Yourself/bis345mentor.com | Page 24

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) Part F: Practice using the“ IN” operator( 5 points) Part G: Understanding“ NULL”( 5 points) Part H: Using a composite condition( 5 points)
Part I: Using a“ DATE” type variable and Concatenating Column Output( 5 points)