BIS 245 Week 5 Chapter 6 Quiz

 BIS 245 Week 5 Chapter 6 Quiz | Devry University -Answered 

Question 1- Which of the following report sections prints column headings, page numbers, or dates at the top of every page?

A.      Report Footer

B.      Page Header  (Correct)

C.      Page Footer

D.      Group Header

Question 2- Which of the following is used to enclose fields in a calculated expression?

A.      square brackets  (Correct)

B.      plus signs

C.      parentheses

D.      dollar signs

Question 3 -Which of the following report sections prints page numbers or dates at the bottom of each page?

A.      Report Footer

B.      Page Header

C.      Page Footer (Correct)

D.      Group Header

Question 4- Which of the following Access date functions adds to a date?

A.      DateSerial()

B.      DateAdd()  (Correct)

C.      DateDiff()

D.      DatePart()

Question 5- Which of the following views is not used to edit a main report?

A.      Design view  (correct)

B.      Layout view

C.      Print Preview view

D.      Report view

Question 6- Which of the following chart types is used to show data as a percentage of the whole?

A.      Column

B.      Combo

C.      Line

D.      Pie( correct)

Question 7- Which of the following formatting properties of a control sets a fixed number of decimal places to display?

A.      Decimal Places  (correct)

B.      Visible

C.      Back Color

D.      Fore Color

Question 8- Which of the following font characteristics is not listed in the Property Sheet?

A.      Font Name

B.      Font Size

C.      Font Underline

D.      Border style (correct)

Question 9- Which of the following is inserted within another report?

A.      subreport  (correct)

B.      main report

C.      separate report

D.      section report

Question 10- Which of the following is a tool that makes it easier to build four different types of queries?

A.      Query Wizard (correct)

B.      Crosstab Query Wizard

C.      Find Duplicates Query Wizard

D.      Find Unmatched Records Query Wizard

Question 11- Which of the following is not a common report modification?

A.      Adjust the size and spacing of the text box and label controls.

B.      Modify font characteristics or formatting of text boxes

C.      . Change the border property or back color property of the controls or sections.

D.      Accepting the size of the subreport or the sections on both the main report and the subreport. (correct)

Question 12- Which of the following deletes records from a table in a database?

A.      update query

B.      append query

C.      delete query (correct)

D.      make table query

Question 13- Once you add a subreport to a main report, how does it exist?

A.      as a secondary object

B.      as a main object (correct)

C.      as a separate object

D.      as a section object

Question 14- Which of the following creates a new table in a database and also copies the records into the new table?

A.      update query (correct)

B.      append query

C.      delete query

D.      make table query

Question 15- On how many dimensions does a crosstab query summarize data?

A.      Two (correct)

B.      three

C.      four

D.      five

Question 16- Which of the following formatting properties of control sets the fill color of a control?

A.      Decimal Places

B.      Visible

C.      Back Color (correct)

D.      Fore Color

Question 17- Which of the following must go at the beginning of calculated expressions in Access?

A.      = (correct)

B.      +

C.      (

D.      [

Question 18- How many action queries can you create in Access?

A.      two

B.      three

C.      four (correct)

D.      five

Question 19- Which of the following would you use to conceal repeated values in a report?

A.      Enabled property

B.      Calculated controls

E.       Hide Duplicates property  (correct)

C.      Control Source property