BIS 245 Final Exam Answer (GRADED A++) 2022.

BIS 245 Final Exam Answer (Updated) 1. (TCO 1) Which object would you use to enter, delete, or modify data? (Points : 5) Criteria Form Query Table Question 2. 2. (TCO 1) In a table the _____ view is where you add, edit, and delete records. (Points : 5) Design Datasheet SQL Layout Question 3. 3. (TCO 1) When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given. (Points : 5) Label Tool Tabular Layout Report Blank Report Tool Report Wizard Question 4. 4. (TCO 1) All of the following filters work EXCEPT (Points : 5) filter by selection with an equal condition. filter by selection with a comparison operator. filter by selection with an edit operator. filter by form with a comparison operator. Question 5. 5. (TCO 1) A Report section that is used to summarize grouped field data is (Points : 5) detail. detail. group header. group footer. report footer. Question 6. 6. (TCO 2) For the following image, which of the following is TRUE? Image Description: An OrderDetail Table with Primary keys of OrderID and ProductID and fields of UnitPrice, Quantity and Discount is related to an Orders Table that has an infinity symbol on the Order Details Table and a number 1 on the Orders Table. The Orders Table has a Primary key of OrderID with additional table fields: CustomerID, EmployeeID, OrderDate, REquiredDate, ShipperDate, ShipVia, Freight, ShipName, ShipAddress, Ship City, ShipRegion, ShipPostalCode, ShipCountry. (Points : 5) Hi there! Get instant help with Devry BIS 245 Final Exam Answer (Updated) Without paying anything upfront. FREE QUOTE 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. Question 7. 7. (TCO 2) A single Crow’s Foot at the left-most end of a relationship line would indicate (Points : 5) a many-to-many relationship. a one-to-many relationship. a one-to-one relationship. no relationship. Question 8. 8. (TCO 3) Which of the following should be considered when designing a database? (Points : 5) How calculated fields are used Store data in its smallest parts The relationship between attribute keys The relationships between records Question 9. 9. (TCO 3) A functional dependency is (Points : 5) a logical relationship between attributes of a table. a logical primary key. a composite key. a unique identifier. Question 10. 10. (TCO 3) Which of the following is NOT true of a property? (Points : 5) A property is an object’s characteristic or attribute. Tables, forms, queries, and reports have a set of properties. A property sheet is used to make changes. Design properties are displayed in Datasheet view. Question 11. 11. (TCO 4) In terms of data types and their uses, which one of the following is NOT correct? (Points : 5) The TEXT data type can be used for Last Name. The Date/Time data type can be used for 10/31/2012. The Currency data type can be used for Account balance. The AutoNumber data type can be used for Customer Name. 1. (TCO 5) Which form type displays records in a tabular format similar to a Datasheet view but has more editing options, such as adding graphics? (Points : 5) Datasheet Form Multiple Items Form Split Form Subform Question 2. 2. (TCO 5) The following are form creation tools EXCEPT (Points : 5) blank form. form design. form layout. Form Wizard. Question 3. 3. (TCO 6) Queries are objects in a database based on one or more underlying (Points : 5) forms. modules. tables. macros. Question 4. 4. (TCO 6) The benefit of a relationship is to (Points : 5) efficiently combine data from related tables. facilitate how Access will manage the relationship. determine which fields to include in each table. minimize data redundancy. Question 5. 5. (TCO 9) A deletion anomaly is (Points : 5) deleting facts about one entity successfully. deleting a table. deleting facts about one entity and deleting facts about another entity. deleting only one fact from a column. Question 6. 6. (TCO 2) Which of the following statements best describes data mining? (Points : 5) It is the determining of future volume of sales. It is the predicting of future customer buying behavior. It is identifying patterns or relationships through a process of analyzing large quantities of data. It is tracking customer purchasing behavior. Question 7. 7. (TCO 8) All of the following describe a Navigation Form EXCEPT (Points : 5) click the Create tab and then Navigation in the Forms group to create a Navigation form. is another term for a Switchboard Manager. helps users open forms and reports. has the look and feel of a web form. Question 8. 8. (TCO 9) A good password should have (Points : 5) a combination of five letters. a combination of six to eight letters in uppercase and lowercase, numbers, and symbols. a word or name that is easy to remember by the user, such as the name of their children. part of your account name. Question 9. 9. (TCO 9) All of the following describe a certification authority EXCEPT (Points : 5) a certification authority company provides a digital signature when a high level of security is needed to protect the contents of a database. a certification authority is a commercial company that is highly regulated in most countries. a fee is charged for the service of issuing and validating identities using a digital signature. certification authority companies establish their own rules and regulations that users must follow. Question 10. 10. (TCO 10) ACCDE files (Points : 5) deny users permission to create and change forms and reports within a database. deny users permission to create forms and reports but will allow them to modify forms and reports. give users permission to create and change forms and reports within a database. give users permission to fully access a database. Question 11. 11. (TCO 4) Which of the following is NOT true of a ship date field? (Points : 5) A ship date is considered a constant. A ship date would be defined as a date/time field. A ship date would be defined as a calculated field. Date arithmetic can be applied to a ship date field. 4. (TCO 4) What is a relational database management system and how does it relate to a database administrator? (Points : 40) 2. (TCO 2) Explain business logic and describe how it relates to a relational database. (Points : 40) 3. (TCO 4) Explain the terms entity and attribute. Describe an example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes. (Points : 40) 1. (TCO 1) What role do databases play in today’s business world and why are they important? Provide two specific examples of how a database might be used by a business. (Points : 40) 1. Question: (TCO 1) The easiest way to create a report is to use the following report tool. Student Answer: Blank Report Report Layout Report Design Report Wizard Question 2. Question: (TCO 1) A report footer student Answer: is used to print page numbers on the report. prints group statistics at the end of the report. prints grand totals at the end of the report. All of the above Question 3. Question: (TCO 1) Which report section would be used to summarize grouped field data? Student Answer: Detail Group Header Group Footer Report Footer Question 4. Question: (TCO 1) To preview the report, which view(s) work best? Student Answer: Report view or Design view. Layout view or Print view. Design view. Print view. Question 5. Question: (TCO 1) Grouping data in a report will Student Answer: provide grand totals for your report. let you organize and summarize your data. make a report more attractive. allow you to edit data in a record. Question 6. Question: (TCO 1) Modifications to a report can be done in Student Answer: Detail view. Layout view. Print view. All of the above Question 7. Question: (TCO 7) To use the report Wizard, do the following steps first: Student Answer: Click create and click report Wizard. Click report wizard and select the correct table. select the correct fields. All of the above Question 8. Question: (TCO 7) A good use of a report is to Student Answer: create a telephone directory or a financial statement. ask the database a question. create a table or query. create detailed charts. Question 9. Question: (TCO 7) Which is not a report view? Student Answer: Print preview Datasheet view Report view Layout view Question 10. Question: (TCO 7) When modifying a report, the arrange option does the following. Student Answer: To move fields up or down To insert space above or below your position To change the layout of the report All of the above 1. Question: (TCO 2) A required field that is used in entering data is a field that Student Answer: appears with a specific value. can be left blank. cannot be left blank. is selected from a list of values. Question 2. Question: (TCO 2) Validation text is Student Answer: an error message that provides instruction on what to fix when an incorrect value is entered into a field. a list of predefined values that can be entered in a field. a comparison of values entered in two fields. a field that requires a value of characters or text only. Instructor Explanation: See Chapter 5: Grauer section of book. Question 3. Question: (TCO 2) A logical data validation method is a(n) Student Answer: birth date field that cannot exceed a hire date. entered number less than 100 will not display. field left blank will display with a default of zero. social security number entered as is displayed as . Instructor Explanation: See Chapter 5: Grauer section of book. Question 4. Question: (TCO 2) Which of the following will create a lookup field, populate the values in the field, and establish relationships between tables? Student Answer: Design View Fields Group Lookup List Lookup Wizard