BIS 245 Final Exam Study Guide
GUARANTEED PASS!!
Fields - (ANSWER)the smallest data element of a table, such as first name, last name, address,
or phone number.
Records - (ANSWER)a group of related fields representing one entity, such as data for one
person, place, event, or concept.
Tables - (ANSWER)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.
Databases - (ANSWER)A collection of data organized as meaningful information that can be
accessed, managed, stored, queried, sorted, and reported.
Forms (object) - (ANSWER)a database object that is used to add, edit or delete table data.
Reports (object) - (ANSWER)An object that contains professional-looking formatted
information from underlying tables or queries.
Macros (object) - (ANSWER)A series of actions that can be programmed to automate tasks.
Modules (object) - (ANSWER)An object that is written using Visual Basic for Applications
(VBA) and adds functionality to the database.
Queries (object) - (ANSWER)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) - (ANSWER)The industry-standard language for defining,
manipulating, and retrieving the data in a database.
Calculated Field - (ANSWER)Produces a value from an expression or function that references or
more existing fields.
Caption Property - (ANSWER)Used to create a more readable label that appears in the top row
in Datasheet view and in forms and reports.
Compact and Repair - (ANSWER)An Access utility that reduces the size of the database and can
repair a corrupt database.
Composite Key - (ANSWER)Primary key that is made of 2 or more fields.
Page 1 of 3
GUARANTEED PASS!!
Fields - (ANSWER)the smallest data element of a table, such as first name, last name, address,
or phone number.
Records - (ANSWER)a group of related fields representing one entity, such as data for one
person, place, event, or concept.
Tables - (ANSWER)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.
Databases - (ANSWER)A collection of data organized as meaningful information that can be
accessed, managed, stored, queried, sorted, and reported.
Forms (object) - (ANSWER)a database object that is used to add, edit or delete table data.
Reports (object) - (ANSWER)An object that contains professional-looking formatted
information from underlying tables or queries.
Macros (object) - (ANSWER)A series of actions that can be programmed to automate tasks.
Modules (object) - (ANSWER)An object that is written using Visual Basic for Applications
(VBA) and adds functionality to the database.
Queries (object) - (ANSWER)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) - (ANSWER)The industry-standard language for defining,
manipulating, and retrieving the data in a database.
Calculated Field - (ANSWER)Produces a value from an expression or function that references or
more existing fields.
Caption Property - (ANSWER)Used to create a more readable label that appears in the top row
in Datasheet view and in forms and reports.
Compact and Repair - (ANSWER)An Access utility that reduces the size of the database and can
repair a corrupt database.
Composite Key - (ANSWER)Primary key that is made of 2 or more fields.
Page 1 of 3
