BIS245 WEEK 8: FINAL EXAM AND CORRECT ANSWERS HIGHLIGHTED 2021

Document Content and Description Below

Question 1 5 / 5 pts (CO 1) A primary key is a field or set of fields that uniquely identifies a record. a key that uniquely identifies columns in a table. Correct! the key used to uniquely i... dentify a record in a table. a nonunique value. Question 2 5 / 5 pts (CO 1) What Microsoft Access feature would give a United Parcel Service (UPS) manager the ability to ask questions like “How many UPS tubes were shipped Monday?” and “What was the total revenue generated from UPS Express box large in November 2017?” Parameter query Primary keys Correct! Table connections or query Foreign keys Question 3 0 / 5 pts (CO 1) Which one of the following tools is the quickest way to create a tabular report in MS Access based on the selected table or query? Report Design tool Correct Answer Report Wizard tool You Answered Blank Report tool Report tool options Question 4 5 / 5 pts (CO 1) Most of the printed documents generated by managers using Access will come from queries. Correct! reports. tables. forms. Question 5 3 / 5 pts (CO 1) A Report section that is used to summarize grouped field data is Correct Answer group footer. report footer. group header. You Answered detail. Question 6 5 / 5 pts (CO 2) A table is also recognized as a(n) domain. Correct! entity. key. cardinality. Question 7 1 / 5 pts (CO 2) SQL is a fourth-generation language that is Correct Answer table oriented and nonprocedural. oriented toward static data. flat-file oriented and nonprocedural. You Answered procedural and record oriented. Question 8 5 / 5 pts (CO 3) Which of the following should be considered when designing a database? How calculated fields are used The relationships between records The relationship between attribute keys Correct! Store data in its smallest parts Question 9 5 / 5 pts (CO 3) The following data type would appear as a checkbox in a table. Attribute Correct! Yes/No Text Number Question 10 5 / 5 pts (CO 3) Which of the following does NOT describe a caption property? The label allows spaces between words. A label can substitute for a field name in datasheet view. The caption appears in datasheet view, form, and report. Correct! The label can be used in place of a field name in an expression. [Show More]

Last updated: 1 year ago

Preview 1 out of 11 pages