BIS 245 Final Exam Latest Updated 2024
Queries (object) - answers-Enables you to create queries; the Design view
is divided into 2 parts - top portion displays the tables and the bottom
portion (known as the query design grid) displays the fields and criteria.
Structured Query Language (SQL) - answers-The industry-standard
language for defining, manipulating, and retrieving the data in a database.
Calculated Field - answers-Produces a value from an expression or
function that references or more existing fields.
Caption Property - answers-Used to create a more readable label that
appears in the top row in Datasheet view and in forms and reports.
Compact and Repair - answers-An Access utility that reduces the size of
the database and can repair a corrupt database.
Composite Key - answers-Primary key that is made of 2 or more fields.
, Criterion - answers-A number, text phase, or an expression used to
select records.
Data type - answers-Determines the type of data that can be entered and
the operations that can be performed on that data.
Data validation - answers-A set of constraints or rules that help control
how data is entered into a field.
Database Management System (DBMS) - answers-A software system that
provides the tools needed to create, maintain, and use a database.
Date arithmetic - answers-The process of adding or subtracting one date
from another, or adding or subtracting a constant from a date.
Delete Query - answers-A query that selects records from a table and
then removes them from a table.
Queries (object) - answers-Enables you to create queries; the Design view
is divided into 2 parts - top portion displays the tables and the bottom
portion (known as the query design grid) displays the fields and criteria.
Structured Query Language (SQL) - answers-The industry-standard
language for defining, manipulating, and retrieving the data in a database.
Calculated Field - answers-Produces a value from an expression or
function that references or more existing fields.
Caption Property - answers-Used to create a more readable label that
appears in the top row in Datasheet view and in forms and reports.
Compact and Repair - answers-An Access utility that reduces the size of
the database and can repair a corrupt database.
Composite Key - answers-Primary key that is made of 2 or more fields.
, Criterion - answers-A number, text phase, or an expression used to
select records.
Data type - answers-Determines the type of data that can be entered and
the operations that can be performed on that data.
Data validation - answers-A set of constraints or rules that help control
how data is entered into a field.
Database Management System (DBMS) - answers-A software system that
provides the tools needed to create, maintain, and use a database.
Date arithmetic - answers-The process of adding or subtracting one date
from another, or adding or subtracting a constant from a date.
Delete Query - answers-A query that selects records from a table and
then removes them from a table.