ISTM 210 Management Information Systems
Final Exam – Access Terms (Phinney, TAMU)
2026/2027
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
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
Does access let you use spaces in your field names? - correct answer-Yes, but not
recommended
Short text is limited to how many characters? - correct answer-225
Long text is limited to how many characters? - correct answer-65,536
What does an input mask do? - correct answer-This is used to set rules for how
the data will be entered for the field. For example, you can use an input mask to
make sure that users enter 10 digits for a telephone number.
What is a validation rule - correct answer-They are used to have Access check
values when they are entered into a table to make sure they fit a specific rule. For
Final Exam – Access Terms (Phinney, TAMU)
2026/2027
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
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
Does access let you use spaces in your field names? - correct answer-Yes, but not
recommended
Short text is limited to how many characters? - correct answer-225
Long text is limited to how many characters? - correct answer-65,536
What does an input mask do? - correct answer-This is used to set rules for how
the data will be entered for the field. For example, you can use an input mask to
make sure that users enter 10 digits for a telephone number.
What is a validation rule - correct answer-They are used to have Access check
values when they are entered into a table to make sure they fit a specific rule. For
