ANALYTICS FINAL EXAMINATION TEST 2026
QUESTIONS AND SOLUTIONS GRADED A+
● which of the following is not true about databases Answer:
summarized and classified to make data available to the decision makers
● which of the following is not an advantage that automated databases
have over paper databases Answer: without paper databases, a business
cannot compete
● you are reading a report that shows Company A generated $2000 last
week. this would be _______ Answer: information
● ________ is/are facts about people, events, things or ideas Answer:
Data
● Access is a _______ DBMS Answer: relational
● A DBMS is a _______ Answer: database management system
● which of the following is not a reason to use access Answer: access is
often used by multiple users at the same time
,● which of the following is not a main object in an access database
Answer: script
● which of the following is not true about creating new databases
Answer: you can use a template; however, you need to create your own
forms and reports
● a ______ is a structure of a database with table, fields, forms, queries
and reports Answer: template
● which of the following is not true about database templates Answer: a
template is a sample database that has pre-supplied data
● which of the following should not be done if access gives you a
security warning about your database Answer: enable the content.
nothing bad will happen, even if there is a virus embedded into the file
● when you open a database, access displays the _____ on the left side
Answer: navigation pane
● the _____ bar open/close button at the top of the pane open and closes
the pane Answer: shutter
, ● the navigation pane allows for all of the following views except
Answer: queries and related views
● to help you find _____, access provides a search box Answer: objects
● which of the following is not an access file extension Answer:
ACCTM
● a _____ is the file extension for an access 2002-2003 database file
Answer: MDB
● a ______ is the file extension for an access 2007-2013 database
template Answer: ?
● which of the following is not true regarding tables and relational
databases Answer: do not use special characters, such as underscore, in
table names
● how is access different from excel Answer: access allows for multiple
tables with relationships between the tables
● which of the following is not a problem that can be caused by using
excel to store data Answer: data redundancy
QUESTIONS AND SOLUTIONS GRADED A+
● which of the following is not true about databases Answer:
summarized and classified to make data available to the decision makers
● which of the following is not an advantage that automated databases
have over paper databases Answer: without paper databases, a business
cannot compete
● you are reading a report that shows Company A generated $2000 last
week. this would be _______ Answer: information
● ________ is/are facts about people, events, things or ideas Answer:
Data
● Access is a _______ DBMS Answer: relational
● A DBMS is a _______ Answer: database management system
● which of the following is not a reason to use access Answer: access is
often used by multiple users at the same time
,● which of the following is not a main object in an access database
Answer: script
● which of the following is not true about creating new databases
Answer: you can use a template; however, you need to create your own
forms and reports
● a ______ is a structure of a database with table, fields, forms, queries
and reports Answer: template
● which of the following is not true about database templates Answer: a
template is a sample database that has pre-supplied data
● which of the following should not be done if access gives you a
security warning about your database Answer: enable the content.
nothing bad will happen, even if there is a virus embedded into the file
● when you open a database, access displays the _____ on the left side
Answer: navigation pane
● the _____ bar open/close button at the top of the pane open and closes
the pane Answer: shutter
, ● the navigation pane allows for all of the following views except
Answer: queries and related views
● to help you find _____, access provides a search box Answer: objects
● which of the following is not an access file extension Answer:
ACCTM
● a _____ is the file extension for an access 2002-2003 database file
Answer: MDB
● a ______ is the file extension for an access 2007-2013 database
template Answer: ?
● which of the following is not true regarding tables and relational
databases Answer: do not use special characters, such as underscore, in
table names
● how is access different from excel Answer: access allows for multiple
tables with relationships between the tables
● which of the following is not a problem that can be caused by using
excel to store data Answer: data redundancy
