BIS 245 Week 8 Final Exam LATEST UPDATE 2021.(Rated A).

(TCO 1) Which object would you use to enter, delete, or modify data? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Access 2010 Comprehensive 2. Question : (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? Student Answer: Criteria Form Query Instructor Explanation: Table Chapter 1: Microsoft Access 2010 Comprehensive 3. Question : (TCO 1) To design a report you should do all of the following EXCEPT Student Answer: draw a paper design of the report. identify all sources of data, fields and groups. input the data. Instructor Explanation: select a reporting tool. Chapter 1: Microsoft Access 2010 Comprehensive 4. Question : (TCO 1) Which of the following is NOT a Report Section? Student Answer: Detail Group Footer Page Footer Instructor Explanation: Summary Chapter 4: Microsoft Access 2010 Comprehensive 5. Question : (TCO 1) A Detail line is used to Student Answer: print more detailed information on one record only. provide additional field information on a record. repeat data for each record in the record source. Instructor Explanation: All of the above Chapter 4: Microsoft Access 2010 Comprehensive 6. Question : (TCO 2) For the following image, which of the following is TRUE? Student Answer: The OrderID field will be unique within both the Orders and Order Details tables. Within the Orders table, the OrderID field will contain more than one of the same value. Within the Order Details table, the OrderID field will contain more than one of the same value. Within the Orders Details table, the ProductID field will contain unique values only. Instructor Explanation: Chapter 2: Frost Textbook 7. Question : (TCO 2) A symbol used in ER diagrams for an entity is a Student Answer: box. diamond. line. Instructor Explanation: triangle. Chapter 2: Frost Textbook 8. Question : (TCO 3) A property that provides a "user friendly" name to a column in Datasheet View is a Student Answer: caption. default value. input mask. Instructor Explanation: rule. Chapter 2: Microsoft Access 2010 Comprehensive 9. Question : (TCO 3) Summarized data in an easy-to-read view is known as a Student Answer: design. PivotTable. report.