Diff: 3 Page Ref: 23-25
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
80) Microsoft Access is considered a "personal database" product. What is a personal database?
Answer: A personal database combines a DBMS with an application generator. The DBMS performs the functions expected of a DBMS such as database creation, processing, and administration. The application generator adds the ability to create and store forms, reports and queries, as well as some other application-related functions.
Diff: 1 Page Ref: 23-25
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
81) What Microsoft Access file format is used by default in Microsoft Access 2019?
Answer: By default, Microsoft Access 2019 supports Access 2007 files formats. Microsoft Access 2007 database files are stored using the .accdb file extension.
Diff: 1 Page Ref: 34
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
82) What problems with storing data on two themes in a list are addressed by database technology?
Answer: First, data updates are simplified because the number of updates is reduced when data appears in more than one location in the list. Second, the possibility of incorrectly entering duplicate data is reduced. Third, the problem of inconsistently entering data values is removed. Finally, the ability to enter data on one theme in the list without having data for the other theme is enhanced.
Diff: 2 Page Ref: 8-9
AACSB: Information Technology
Chapter Obj.: Understand the potential problems with lists
Classification: Concept