SUNY ALBANY BITM 215-Review
Session Test 1 CORRECT 100%
Data - ANSWER-collection of unprocessed items
Database - ANSWER-collection of data organized as meaningful info that can be
accessed, managed, stored, queried, sorted and reported
Information - ANSWER-processed data from a database. The finished product of a
database
objects - ANSWER-main components that are created and used to make the database
function
tables - ANSWER-include data...made up of records and fields about one type of entity.
Ex of entity: student, DVD, CD, piece of furniture
records - ANSWER-represent a complete set of all of the data elements (fields) about
one particular entity
CRITERION - ANSWER-a number, phrase, or expression used to select records in a
table.
fields - ANSWER-the smallest pieces of data found in a table. Examples of fields
include an individual person's first name, last name, and middle initial
caption property - ANSWER-used to create a more readable label- appear in top row in
the data sheet view and in forms/reports-overrides the field name
Validation Rule Property - ANSWER-to restrict data entry in a field. ensure that correct
type of data is entered/ data doesn't violate other enforced properties
field properties - ANSWER-characteristics of a field that determine how the field
looks/behaves
input mask - ANSWER-Simplifies data entry by providing literal characters that are
types for every entry
ex SS# is displayed to user with hyphens
caption - ANSWER-provides a label used in data sheet view or in reports
default value - ANSWER-automatically enter a predetermined value for a field each time
a new record is added to the table
Session Test 1 CORRECT 100%
Data - ANSWER-collection of unprocessed items
Database - ANSWER-collection of data organized as meaningful info that can be
accessed, managed, stored, queried, sorted and reported
Information - ANSWER-processed data from a database. The finished product of a
database
objects - ANSWER-main components that are created and used to make the database
function
tables - ANSWER-include data...made up of records and fields about one type of entity.
Ex of entity: student, DVD, CD, piece of furniture
records - ANSWER-represent a complete set of all of the data elements (fields) about
one particular entity
CRITERION - ANSWER-a number, phrase, or expression used to select records in a
table.
fields - ANSWER-the smallest pieces of data found in a table. Examples of fields
include an individual person's first name, last name, and middle initial
caption property - ANSWER-used to create a more readable label- appear in top row in
the data sheet view and in forms/reports-overrides the field name
Validation Rule Property - ANSWER-to restrict data entry in a field. ensure that correct
type of data is entered/ data doesn't violate other enforced properties
field properties - ANSWER-characteristics of a field that determine how the field
looks/behaves
input mask - ANSWER-Simplifies data entry by providing literal characters that are
types for every entry
ex SS# is displayed to user with hyphens
caption - ANSWER-provides a label used in data sheet view or in reports
default value - ANSWER-automatically enter a predetermined value for a field each time
a new record is added to the table
