BIS 245 Final Exam Study Guide
Calculated Field - -Produces a value from an expression or function that
references or more existing fields.
- Caption Property - -Used to create a more readable label that appears
in the top row in Datasheet view and in forms and reports.
- Compact and Repair - -An Access utility that reduces the size of the
database and can repair a corrupt database.
- Composite Key - -Primary key that is made of 2 or more fields.
- Criterion - -A number, text phase, or an expression used to select
records.
- Data type - -Determines the type of data that can be entered and the
operations that can be performed on that data.
- Data validation - -A set of constraints or rules that help control how
data is entered into a field.
- Database Management System (DBMS) - -A software system that
provides the tools needed to create, maintain, and use a database.
- Databases - -A collection of data organized as meaningful information
that can be accessed, managed, stored, queried, sorted, and reported.
- Date arithmetic - -The process of adding or subtracting one date from
another, or adding or subtracting a constant from a date.
- Delete Query - -A query that selects records from a table and then
removes them from a table.
- Digital Signatures - -Electron, decryption-based, secure stamps of
authentication that confirm who created the file, that the file is valid, and
that no changes have been made to the file after its authentication.
- Encryption - -The process of altering digital information by using an
algorithm to make it unreadable to anyone except those who possess the
key (or secret code).
- Expression Builder - -An Access tool that helps you create more
complicated expressions.
- Field property - -A characteristic of a field that determines how a field
looks and behaves.
Calculated Field - -Produces a value from an expression or function that
references or more existing fields.
- Caption Property - -Used to create a more readable label that appears
in the top row in Datasheet view and in forms and reports.
- Compact and Repair - -An Access utility that reduces the size of the
database and can repair a corrupt database.
- Composite Key - -Primary key that is made of 2 or more fields.
- Criterion - -A number, text phase, or an expression used to select
records.
- Data type - -Determines the type of data that can be entered and the
operations that can be performed on that data.
- Data validation - -A set of constraints or rules that help control how
data is entered into a field.
- Database Management System (DBMS) - -A software system that
provides the tools needed to create, maintain, and use a database.
- Databases - -A collection of data organized as meaningful information
that can be accessed, managed, stored, queried, sorted, and reported.
- Date arithmetic - -The process of adding or subtracting one date from
another, or adding or subtracting a constant from a date.
- Delete Query - -A query that selects records from a table and then
removes them from a table.
- Digital Signatures - -Electron, decryption-based, secure stamps of
authentication that confirm who created the file, that the file is valid, and
that no changes have been made to the file after its authentication.
- Encryption - -The process of altering digital information by using an
algorithm to make it unreadable to anyone except those who possess the
key (or secret code).
- Expression Builder - -An Access tool that helps you create more
complicated expressions.
- Field property - -A characteristic of a field that determines how a field
looks and behaves.
