ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Chapter 15 -
Database Software -
correct answer ✅Well thought-out collection of computer files
Tables -
correct answer ✅Where a database holds data.
Consists of records (rows) separated by fields (columns) that can be
queried to produce subsets of information.
Database Management Systems (DBMS) -
correct answer ✅Data is stored in tables which are connected to
other tables, hence a relational database.
Similar to filing cabinets.
Reports -
correct answer ✅Display database information on screen.
,ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Saved Query Files -
correct answer ✅Used to find specific populations (subsets) within
databases.
Forms -
correct answer ✅Overlay data tables and queries for more specific
views of data
Queries -
correct answer ✅Used to find specific populations within a
database.
Entity Relationship Modeling (ERM) -
correct answer ✅Database modeling method used to construct a
theoretical and conceptual representation of data to produce a
schema.
Database Schema -
correct answer ✅"Map" of data tables and their relationships to
one another.
,ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Data Validation Rules -
correct answer ✅Help to ensure the data's integrity.
Attempt to avoid data input errors.
Structured Query Language (SQL) -
correct answer ✅Most widely used standard computing language
for relational databases at it allows a programmer to manipulate
and query data.
Zach Case Study -
correct answer ✅Zach works at a large banking institution.
Zach has to produce an REO (Real Estate Owned) Fact Sheet.
Bank kept piling up foreclosed properties, but Zach kept up.
Executive requested more info from the REO Fact Sheet.
Abby helped Zach find ways to fix this.
, ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Abby helped to import data into Access from Word and helped him
resolve any problems.
Access is now used by the bank thanks to Zach.
Business databases are never distributed.
Data is stored in computer files called tables.
New database is on a network.
Eliminates errors.
Abby suggested various ways of distributing information.
Make new reports based on each department and their activities.
"Filter" to display specific info.
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Chapter 15 -
Database Software -
correct answer ✅Well thought-out collection of computer files
Tables -
correct answer ✅Where a database holds data.
Consists of records (rows) separated by fields (columns) that can be
queried to produce subsets of information.
Database Management Systems (DBMS) -
correct answer ✅Data is stored in tables which are connected to
other tables, hence a relational database.
Similar to filing cabinets.
Reports -
correct answer ✅Display database information on screen.
,ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Saved Query Files -
correct answer ✅Used to find specific populations (subsets) within
databases.
Forms -
correct answer ✅Overlay data tables and queries for more specific
views of data
Queries -
correct answer ✅Used to find specific populations within a
database.
Entity Relationship Modeling (ERM) -
correct answer ✅Database modeling method used to construct a
theoretical and conceptual representation of data to produce a
schema.
Database Schema -
correct answer ✅"Map" of data tables and their relationships to
one another.
,ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Data Validation Rules -
correct answer ✅Help to ensure the data's integrity.
Attempt to avoid data input errors.
Structured Query Language (SQL) -
correct answer ✅Most widely used standard computing language
for relational databases at it allows a programmer to manipulate
and query data.
Zach Case Study -
correct answer ✅Zach works at a large banking institution.
Zach has to produce an REO (Real Estate Owned) Fact Sheet.
Bank kept piling up foreclosed properties, but Zach kept up.
Executive requested more info from the REO Fact Sheet.
Abby helped Zach find ways to fix this.
, ISTM 210 - Exam 4 Review (Chapters
15, 16, and 17 and Access) Questions
& Answers (Grade A+)
Abby helped to import data into Access from Word and helped him
resolve any problems.
Access is now used by the bank thanks to Zach.
Business databases are never distributed.
Data is stored in computer files called tables.
New database is on a network.
Eliminates errors.
Abby suggested various ways of distributing information.
Make new reports based on each department and their activities.
"Filter" to display specific info.
