Devry BIS 245 Final Exam Answer,GRADED A.

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 fie ...

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 111223333 is displayed as 111-22-3333. 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 Question 5. Question: (TCO 2) An input mask that will NOT accept a letter (A to Z) in a field value is Student Answer: ?. A. L. #. Question 6. Question: (TCO 5) To edit a form, use the Student Answer: design view. datasheet view. layout view. layout view or design view. Question 7. Question: (TCO 5) A form type that displays records in a tabular format, but has more editing options is a(n) Student Answer: datasheet form. multiple items form. split form. subform. Question 8. Question: (TCO 5) If you click on the form tool, you will open a(n) Student Answer: existing form. new form in design view. new form in layout view. wizard to design a form. Question 9. Question: (TCO 5) The title for a form should be placed in the Student Answer: details area. form header. textbox in the details area. textbox in the form header. Question 10. Question: (TCO 5) All of the following are aggregate functions EXCEPT Student Answer: average. count. minimum. subtract. 1. Question: (TCO 1) When designing a database, you should Student Answer: determine the input and then design the tables. determine the output and then design the tables. develop the forms and then input the data. input the data and then design the reports. Question 2. Question: (TCO 2) All of the following are Access data types EXCEPT Student Answer: autonumber. date/time. number. string. Question 3. Question: (TCO 2) Which wizard is NOT available from the Query Wizard? Student Answer: Crosstab Query Wizard Find Duplicates Query Wizard Simple Query Wizard Summarize Query Wizard Question 4. Question: (TCO 2) Which of the following is a naming convention for field names? Student Answer: autonumber camelcase primary key PPNI Question 5. Question: (TCO 2) A long text field Student Answer: is a link to text information in another file. holds important information that needs to be flagged. is used to store descriptive information and has more than 255 characters. is used to store text information up to 255 characters. Question 6. Question: (TCO 2) Which of the following statements is true about queries? Student Answer: Forms and queries are actually the same thing. Queries can only be based on one table Query results are not saved after the query is executed. The instructions to create a query are not stored in the database. Question 7. Question: (TCO 2) When building a calculated field, formulas can be created using the Student Answer: Form Wizard. Expression Builder. Report Builder. Table Wizard. Question 8. Question: (TCO 2) In Access, the bottom portion of Query Design View that displays the fields and criteria is known as the Student Answer: query design grid. Show Tables dialog. Simple Query Wizard. query datasheet. Question 9. Question: (TCO 6) Which of the following does NOT describe data redundancy? Student Answer: The same data exists in multiple tables. The data is always in linked tables. Data updating must be done in multiple table locations. Data redundancy can result in data anomalies. Question 10. Question: (TCO 6) Which of the following is true about a crosstab query? Student Answer: It is an action query. It is used to retrieve parameter data. It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns. It summarizes unmatched records from a data source. 1. Question: (TCO 2) In a relational database, entities are Student Answer: events. persons. things. All of the above Question 2. Question: (TCO 2) Which of the following is NOT a step in the Database Life Cycle? Student Answer: Database Design Maintenance and Redevelopment Performance Testing Question 3. Question: (TCO 3) Database design refers to Student Answer: developing a database model that will support company operations. focusing on understanding the business and its functional areas or business processes. selecting the specific hardware characteristics based on data storage and data access requirements. the process of converting your ERD into tables, and defining your rows and columns based your entities and attributes. Instructor Explanation: See the Week 3 Lesson. Question 4. Question: (TCO 2) A crow’s foot Student Answer: is a Boolean field. is used to describe attributes. points to the child table. points to the parent table. Question 5. Question: (TCO 2) The term cardinality refers to Student Answer: a count of the total records in a table. a field which is a candidate for a primary key. the number of records in a relationship. the most important field in a table. Question 6. Question: (TCO 2) A primary key Student Answer: can be computer generated. consists of one field only that uniquely identifies each record in a table. is a relationship between two or more tables. All of the above Question 7. Question: (TCO 3) What does not define a composite key? Student Answer: Using two or more fields as a primary key Using three fields as a primary key Using two fields as a primary key Using one field as a primary key Question 8. Question: (TCO 4) Which statement below is NOT true of one-to-many relationships? Student Answer: It is the least-used type of relationship. The table with the primary key must only have one occurrence of each value for the primary key. The foreign key in the related table may have repeating values for the foreign key. An example is that one employee may take multiple orders. Question 9. Question: (TCO 4) Which is NOT true of a calculated field? Student Answer: It cannot be added to queries or reports. The value of a calculated field is produced from an expression. A calculated field references other fields. The result is useful at the moment the calculation is made. Question 10. Question: (TCO 4) Which of the following is a special-definition setting used on a field containing an employee’s date of hire? Student Answer: Date arithmetic Constant Date/time field Calculated field 1. Question: (TCO 2) To create a relationship between two tables, you need at least a Student Answer: data type. query. hyperlink. primary key. Question 2. Question: (TCO 2) In an ER diagram, a crow’s foot is used Student Answer: as a symbol for an entity. to establish tuples. to model attributes. to point toward a child table. Question 3. Question: (TCO 2) Columns in an Access table are called Student Answer: fields. records. relation. tuples. Question 4. Question: (TCO 3) A relational table includes the following conditions EXCEPT Student Answer: column entries and attributes must be the same data type. rows must be in order. cells contain a single data value. columns or attributes have a well defined range of values. Question 5. Question: (TCO 3) In Access, a query result that contained the date November 12, 2011 could have had which of the following query criteria? Student Answer: 11/12/2011 12/11/2011 #12/11/2011# Between #10/01/2011# And #11/12/2011# Question 6. Question: (TCO 3) The field property that ensures that the field is not empty is Student Answer: Format. Required. Validation. Validation Rule. Question 7. Question: (TCO 3) All of the following are true about a property EXCEPT Student Answer: a Datasheet View is used to display properties. referenced as an attribute. changes can be made with a property sheet. tables, forms, queries, and reports can have properties. Question 8. Question: (TCO 4) Which of the following is NOT an example of a primary key? Student Answer: ISBN number for a textbook Last name Social Security Number Student ID Question 9. Question: (TCO 4) Which of the following is NOT an Access data type? Student Answer: Text Currency Name Date/Time Question 10. Question: (TCO 2) In Access, which item below is NOT considered a logical operator? Student Answer: Equal And Not Or 1. Question: (TCO 1) A database management system (DBMS) is a collection of programs that Student Answer: store data. manage data. use collections of data. All of the above Question 2. Question: (TCO 1) You should use Access over Excel when Student Answer: you have a large amount of data. you need to create complex charts. you have only one worksheet to handle all of your data. you have extensive subtotals and totals in your worksheet. Question 3.Question: (TCO 1) To create a filtered list on a particular field in a record Student Answer: click on the Home tab, Advanced Filter, and then Filter By Form. click on the Home tab, Filter, and then the Find option. click on the Home tab, Selection, and then pick your criteria. right click on an item in your Field column and then click Sort. Question 4. Question:(TCO 1) The view in Access which looks similar to an Excel spreadsheet is Student Answer: Datasheet. Design. Form. Report. Question 5. Question: (TCO 1) Which view best describes the image below? Student Answer: Datasheet Design Form Report Question 6. Question: (TCO 2) To add, delete, and edit a record, use Student Answer: Datasheet view of a table. Design view of a table. Design view of a query. Report view. Question 7. Question: (TCO 2) Types of relationships between tables do NOT include Student Answer: one-to-one. many-to-many. primary-to-foreign. many-to-one. Question 8. Question: (TCO 1) Excel should be used instead of Access when Student Answer: you have a small amount of data. your data needs to be regrouped in various views. your data needs connectivity to external databases. your data requires a relational database.