BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Database
is a collection of data organized as meaningful information that can be accessed,
managed, stored, queried, sorted, and reported.
Data
is a collection of unprocessed items
ex. Text, Numbers, Images, Audio, Video
Information
- Data is not information, but it is used to make information.
- Information is processed data from a database. The finished product of a database.
- This information is used to make documents, audio, images and videos
Objects
are the main components that are created and used to make the database function.
Tables
include data and are made up of records and fields about one type of entity. Examples
of an entity would be a student, DVD, CD, or a piece of furniture.
Records
represent a complete set of all of the data elements (fields) about one particular entity.
Examples of entities include a person, a place, an event, or a concept.
Criterion
a number, phrase, or expression used to select records in a table.
Fields
are the smallest pieces of data found in a table. Examples of fields include an individual
person's first name, last name, and middle initial.
Field Properties
are the characteristics of a field that determine how the field looks and behaves.
Caption property
used to create a more readable label that will appear in the top row in the Datasheet
view and in forms and reports. It overrides the field name, so if your field name is LN,
you can set the Caption property to Last Name, which is a bit more user friendly
Validation Rule property
to restrict data entry in a field. This will ensure that the correct type of data is entered or
that the data does not violate other enforced properties.
Input Mask
Simplifies data entry by providing literal characters that are types for every entry.
Example: Social Security # would displayed to the user with hyphens (123-45-6789)
Caption
provides a label used in Datasheet view or in reports
Default Value
automatically enter a predetermined value for a field each time a new record is added to
a table. For example, FL could be entered into a state's field if most of your employees
live in Florida
Compacting
GRADED
Database
is a collection of data organized as meaningful information that can be accessed,
managed, stored, queried, sorted, and reported.
Data
is a collection of unprocessed items
ex. Text, Numbers, Images, Audio, Video
Information
- Data is not information, but it is used to make information.
- Information is processed data from a database. The finished product of a database.
- This information is used to make documents, audio, images and videos
Objects
are the main components that are created and used to make the database function.
Tables
include data and are made up of records and fields about one type of entity. Examples
of an entity would be a student, DVD, CD, or a piece of furniture.
Records
represent a complete set of all of the data elements (fields) about one particular entity.
Examples of entities include a person, a place, an event, or a concept.
Criterion
a number, phrase, or expression used to select records in a table.
Fields
are the smallest pieces of data found in a table. Examples of fields include an individual
person's first name, last name, and middle initial.
Field Properties
are the characteristics of a field that determine how the field looks and behaves.
Caption property
used to create a more readable label that will appear in the top row in the Datasheet
view and in forms and reports. It overrides the field name, so if your field name is LN,
you can set the Caption property to Last Name, which is a bit more user friendly
Validation Rule property
to restrict data entry in a field. This will ensure that the correct type of data is entered or
that the data does not violate other enforced properties.
Input Mask
Simplifies data entry by providing literal characters that are types for every entry.
Example: Social Security # would displayed to the user with hyphens (123-45-6789)
Caption
provides a label used in Datasheet view or in reports
Default Value
automatically enter a predetermined value for a field each time a new record is added to
a table. For example, FL could be entered into a state's field if most of your employees
live in Florida
Compacting
