BIS 245 Final Exam Study
Guide
1. the smallest data element of a table, such as first name, last name,
address, or phone number.: Fields
2. a group of related fields representing one entity, such as data for
one person, place, event, or concept.: Records
3. An object used to store and organize data in a series of records (rows)
with each record made up of a number of fields (columns) and is the
foundation of every database.: Tables
4. A collection of data organized as meaningful information that can be
ac- cessed, managed, stored, queried, sorted, and reported.: Databases
5.a database object that is used to add, edit or delete table data.: Forms
(object)
6. An object that contains professional-looking formatted information
from underlying tables or queries.: Reports (object)
7. A series of actions that can be programmed to automate tasks.:
Macros (object)
8. An object that is written using Visual Basic for Applications (VBA) and
adds functionality to the database.: Modules (object)
9. 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.: Queries (object)
10.The industry-standard language for defining, manipulating, and
retrieving the data in a database.: Structured Query Language (SQL)
11.Produces a value from an expression or function that references or
more existing fields.: Calculated Field
12.Used to create a more readable label that appears in the top row
in Datasheet view and in forms and reports.: Caption Property
13.An Access utility that reduces the size of the database and can repair a
corrupt database.: Compact and Repair
14.Primary key that is made of 2 or more fields.: Composite Key
15.A number, text phase, or an expression used to select records.: Criterion
16.Determines the type of data that can be entered and the operations that
can be performed on that data.: Data type
17.A set of constraints or rules that help control how data is entered into
a field.: Data validation
18.A software system that provides the tools needed to create, maintain,
and use a database.: Database Management System (DBMS)
19.The process of adding or subtracting one date from another, or adding
or subtracting a constant from a date.: Date arithmetic
1/2
Guide
1. the smallest data element of a table, such as first name, last name,
address, or phone number.: Fields
2. a group of related fields representing one entity, such as data for
one person, place, event, or concept.: Records
3. An object used to store and organize data in a series of records (rows)
with each record made up of a number of fields (columns) and is the
foundation of every database.: Tables
4. A collection of data organized as meaningful information that can be
ac- cessed, managed, stored, queried, sorted, and reported.: Databases
5.a database object that is used to add, edit or delete table data.: Forms
(object)
6. An object that contains professional-looking formatted information
from underlying tables or queries.: Reports (object)
7. A series of actions that can be programmed to automate tasks.:
Macros (object)
8. An object that is written using Visual Basic for Applications (VBA) and
adds functionality to the database.: Modules (object)
9. 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.: Queries (object)
10.The industry-standard language for defining, manipulating, and
retrieving the data in a database.: Structured Query Language (SQL)
11.Produces a value from an expression or function that references or
more existing fields.: Calculated Field
12.Used to create a more readable label that appears in the top row
in Datasheet view and in forms and reports.: Caption Property
13.An Access utility that reduces the size of the database and can repair a
corrupt database.: Compact and Repair
14.Primary key that is made of 2 or more fields.: Composite Key
15.A number, text phase, or an expression used to select records.: Criterion
16.Determines the type of data that can be entered and the operations that
can be performed on that data.: Data type
17.A set of constraints or rules that help control how data is entered into
a field.: Data validation
18.A software system that provides the tools needed to create, maintain,
and use a database.: Database Management System (DBMS)
19.The process of adding or subtracting one date from another, or adding
or subtracting a constant from a date.: Date arithmetic
1/2
