ISTM 210 TAMU Phinney Final Exam
Access Terms Questions & Answers
(Grade A+)
What are databases best at doing? -
correct answer ✅Storing data
What is Microsoft access? -
correct answer ✅A database application
What are the 4 types of objects in access, and what is each's
function? -
correct answer ✅Tables- are used to store the data in Access
Queries-are used to find the specific data you need from the
database.
Forms- present the data in a table in a separate window one record
at a time.
Reports- allow you to organize and present the data in your
database.
What kind of database is access? -
correct answer ✅Relational; meaning data is stored in tables
, ISTM 210 TAMU Phinney Final Exam
Access Terms Questions & Answers
(Grade A+)
When the data from two tables are associated, we say there is
a________ between the tables. -
correct answer ✅Relationship
What is an entity? -
correct answer ✅Database tables store information about specific
things called entities. Customers in a table would be an entity in the
database.
What is a record and where is it stored -
correct answer ✅The collection of information you have for an
instance of an entity is called a record. Records are stored in the
rows of tables.
What is an attribute? -
correct answer ✅Data stored for each database record is an
attribute. Attributes are stored in the columns of tables. In the case
of our customer table; first and last name, email address, and the
elements of the physical address are all attributes.
Access refers to the attributes of a table as ______? -
correct answer ✅Fields
Access Terms Questions & Answers
(Grade A+)
What are databases best at doing? -
correct answer ✅Storing data
What is Microsoft access? -
correct answer ✅A database application
What are the 4 types of objects in access, and what is each's
function? -
correct answer ✅Tables- are used to store the data in Access
Queries-are used to find the specific data you need from the
database.
Forms- present the data in a table in a separate window one record
at a time.
Reports- allow you to organize and present the data in your
database.
What kind of database is access? -
correct answer ✅Relational; meaning data is stored in tables
, ISTM 210 TAMU Phinney Final Exam
Access Terms Questions & Answers
(Grade A+)
When the data from two tables are associated, we say there is
a________ between the tables. -
correct answer ✅Relationship
What is an entity? -
correct answer ✅Database tables store information about specific
things called entities. Customers in a table would be an entity in the
database.
What is a record and where is it stored -
correct answer ✅The collection of information you have for an
instance of an entity is called a record. Records are stored in the
rows of tables.
What is an attribute? -
correct answer ✅Data stored for each database record is an
attribute. Attributes are stored in the columns of tables. In the case
of our customer table; first and last name, email address, and the
elements of the physical address are all attributes.
Access refers to the attributes of a table as ______? -
correct answer ✅Fields
