MIS 301 Access Terms
Table (entity) - correct answer ✔collection of fields that describe a person,
place, object, event, or idea
Field (attribute) - correct answer ✔single characteristic or attribute of a
person, place, object, event, or idea. Each field contains one entry of data,
NOT information
Field Value - correct answer ✔specific value, or content, of a field; only one
entry can be made per field
Record - correct answer ✔a collection of fields in a table, typically aligned in
a row of a table in the Datasheet View
Data Type - correct answer ✔portion, in Design View, that allows you to
determine what type of data can only be entered into a field, when in
Datasheet View. For example, a Number DataType can only contain numbers,
nothing else. Short Text can contain 255 characters, Date/Time can only
contain either dates or times within a field.
Primary Key - correct answer ✔a field, or a collection of fields, whose values
uniquely identify each record in a table; no two records can contain the same
value for the primary key field . They are nonrepeating, typically numerical, bu
are now becoming more alphanumerical
Foreign Key - correct answer ✔a primary key from one table that appears on
another table as a regular field; the purpose of placing the same field in
another rable is to create a relationship between the two tables which allows
us to create queries and answer specific business questions. Foreign keys
can repeat.
Table (entity) - correct answer ✔collection of fields that describe a person,
place, object, event, or idea
Field (attribute) - correct answer ✔single characteristic or attribute of a
person, place, object, event, or idea. Each field contains one entry of data,
NOT information
Field Value - correct answer ✔specific value, or content, of a field; only one
entry can be made per field
Record - correct answer ✔a collection of fields in a table, typically aligned in
a row of a table in the Datasheet View
Data Type - correct answer ✔portion, in Design View, that allows you to
determine what type of data can only be entered into a field, when in
Datasheet View. For example, a Number DataType can only contain numbers,
nothing else. Short Text can contain 255 characters, Date/Time can only
contain either dates or times within a field.
Primary Key - correct answer ✔a field, or a collection of fields, whose values
uniquely identify each record in a table; no two records can contain the same
value for the primary key field . They are nonrepeating, typically numerical, bu
are now becoming more alphanumerical
Foreign Key - correct answer ✔a primary key from one table that appears on
another table as a regular field; the purpose of placing the same field in
another rable is to create a relationship between the two tables which allows
us to create queries and answer specific business questions. Foreign keys
can repeat.
