BIS 245 Final Exam Study Guide
Questions With Complete
SolutionsA+GRADED
Fields - correct answer...✔✔the smallest data element of a table, such as
first name, last name, address, or phone number.
Records - correct answer...✔✔a group of related fields representing one
entity, such as data for one person, place, event, or concept.
Tables - correct 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 - correct answer...✔✔A collection of data organized as
meaningful information that can be accessed, managed, stored, queried,
sorted, and reported.
Forms (object) - correct answer...✔✔a database object that is used to add,
edit or delete table data.
Reports (object) - correct answer...✔✔An object that contains
professional-looking formatted information from underlying tables or
queries.
Macros (object) - correct answer...✔✔A series of actions that can be
programmed to automate tasks.
Modules (object) - correct answer...✔✔An object that is written using
Visual Basic for Applications (VBA) and adds functionality to the database.
Queries (object) - correct 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.
AGRADESOLUTIONS
Questions With Complete
SolutionsA+GRADED
Fields - correct answer...✔✔the smallest data element of a table, such as
first name, last name, address, or phone number.
Records - correct answer...✔✔a group of related fields representing one
entity, such as data for one person, place, event, or concept.
Tables - correct 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 - correct answer...✔✔A collection of data organized as
meaningful information that can be accessed, managed, stored, queried,
sorted, and reported.
Forms (object) - correct answer...✔✔a database object that is used to add,
edit or delete table data.
Reports (object) - correct answer...✔✔An object that contains
professional-looking formatted information from underlying tables or
queries.
Macros (object) - correct answer...✔✔A series of actions that can be
programmed to automate tasks.
Modules (object) - correct answer...✔✔An object that is written using
Visual Basic for Applications (VBA) and adds functionality to the database.
Queries (object) - correct 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.
AGRADESOLUTIONS
