TAMU ISTM 210 (Curtsinger) Exam 4
Exam Questions & Answers (Grade
A+)
Store data -
correct answer ✅Tables
Find & retrieve specific data from tables -
correct answer ✅Queries
View, add, & update data ONE record at a time; simplifies data
entry into a table -
correct answer ✅Forms
Printing data in a certain layout, formatting the data -
correct answer ✅Reports
Field, entity, attribute -
correct answer ✅Different names for columns in access
To define what data/information is being shown -
correct answer ✅Purpose of fields
,TAMU ISTM 210 (Curtsinger) Exam 4
Exam Questions & Answers (Grade
A+)
Defines what type of data you are inserting into the field and how it
will look -
correct answer ✅Data type
Short text, long text, number, currency, date & time, Yes/No,
AutoNumber -
correct answer ✅Data type examples
First name, last name, customer ID, email -
correct answer ✅Field examples
Modify the records -
correct answer ✅Datasheet view/object view
Modify the fields and their data types; Includes field name, data
type, and description columns -
correct answer ✅Design view
-
correct answer ✅What the design view looks like
, TAMU ISTM 210 (Curtsinger) Exam 4
Exam Questions & Answers (Grade
A+)
-
correct answer ✅What the datasheet view looks like
Information about a specific instance -
correct answer ✅What information do records hold?
Characteristics included in the table (Aka field name) -
correct answer ✅Attribute
Define characteristics kept track of in the table -
correct answer ✅What information do fields hold?
Unique identification, used to create relationships with other tables
with the same field names (parent) -
correct answer ✅Primary key
Links back to the primary key (child) -
correct answer ✅Foreign key
Exam Questions & Answers (Grade
A+)
Store data -
correct answer ✅Tables
Find & retrieve specific data from tables -
correct answer ✅Queries
View, add, & update data ONE record at a time; simplifies data
entry into a table -
correct answer ✅Forms
Printing data in a certain layout, formatting the data -
correct answer ✅Reports
Field, entity, attribute -
correct answer ✅Different names for columns in access
To define what data/information is being shown -
correct answer ✅Purpose of fields
,TAMU ISTM 210 (Curtsinger) Exam 4
Exam Questions & Answers (Grade
A+)
Defines what type of data you are inserting into the field and how it
will look -
correct answer ✅Data type
Short text, long text, number, currency, date & time, Yes/No,
AutoNumber -
correct answer ✅Data type examples
First name, last name, customer ID, email -
correct answer ✅Field examples
Modify the records -
correct answer ✅Datasheet view/object view
Modify the fields and their data types; Includes field name, data
type, and description columns -
correct answer ✅Design view
-
correct answer ✅What the design view looks like
, TAMU ISTM 210 (Curtsinger) Exam 4
Exam Questions & Answers (Grade
A+)
-
correct answer ✅What the datasheet view looks like
Information about a specific instance -
correct answer ✅What information do records hold?
Characteristics included in the table (Aka field name) -
correct answer ✅Attribute
Define characteristics kept track of in the table -
correct answer ✅What information do fields hold?
Unique identification, used to create relationships with other tables
with the same field names (parent) -
correct answer ✅Primary key
Links back to the primary key (child) -
correct answer ✅Foreign key
