Answer: .accdb
Diff: 2 Page Ref: 34
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
65) By default, Microsoft Access 2019 saves data files in the ________ file format.
Answer: Access 2007
Diff: 2 Page Ref: 34
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
66) Microsoft Access 2019 generates surrogate key values when the ________ data type is used.
Answer: AutoNumber
Diff: 2 Page Ref: 42
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
67) A relational database stores data in the form of ________.
Answer: tables
Diff: 2 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
68) It is almost always best to design a table in a database so that it contains data on ________ theme.
Answer: one
Diff: 2 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
69) A(n) ________ is a set of one or more computer programs that serves as an intermediary between the user and the DBMS.
Answer: database application
Diff: 2 Page Ref: 18
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
70) In a database system, the ________ creates and processes forms.
Answer: database application
Diff: 3 Page Ref: 21
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
71) The purpose of a database is to help people ________.
Answer: keep track of things
Diff: 1 Page Ref: 7
AACSB: Information Technology
Chapter Obj.: Understand the reasons for using a database
Classification: Concept
72) What is a surrogate key and how does Microsoft Access 2019 create surrogate keys?
Answer: A surrogate key is usually a computer-generated unique number that serves as the identifier of each row in a table. Microsoft Access 2019 generates surrogate keys by using the Access AutoNumber data type.
Diff: 1 Page Ref: 42
AACSB: Information Technology
Chapter Obj.: Learn the elements of a database
Classification: Concept
73) Briefly describe the four components of a database system.
Answer: The components of a database system are: (1) the users, (2) the application programs, (3) the DBMS, and (4) the database. The users are the people that will employ the system to input new data, modify existing data, and delete data in order to perform their jobs. The application programs are computer programs that act as intermediaries between the users and the DBMS. The application programs produce forms, reports, and queries; they also translate user actions into data management requests for the DBMS. The DBMS manipulates the database. It receives data management requests from the computer applications and translates them into read and write commands for the database. The database contains the actual user data that the users need to perform their jobs.
Diff: 2 Page Ref: 18-21
AACSB: Information Technology
Chapter Obj.: Know the components of a database system
Classification: Concept
74) What components are included in a database?
Answer: The database contains user data, metadata, indexes and other overhead data, and application metadata. User data is the data from the users' environment that they want to track. Metadata is data about the structure of the database. Indexes and other overhead data are structures that the database uses to improve performance. Finally, the application metadata is data about forms, reports, and other application components that some databases, particularly those created with desktop DBMS products, store with the database.
Diff: 2 Page Ref: 19
AACSB: Information Technology
Chapter Obj.: Know the components of a database system
Classification: Concept
75) What is "metadata," and how does it relate to the definition of a database?