BIS 245 FINAL EXAM STUDY GUIDE
(LATEST UPDATE 2026-2027) REAL
QUESTIONS AND VERIFIED ANSWERS
100% CORRECT ALREADY {GRADE A} -
DeVry University
Index - correct answer Reduces the time it takes to run queries and reports
Indexed Property - correct answer Setting that enables quick sorting in primary key
order and quick retrieval based on the primary key
Input Mask - correct answer Enables you to restrict the data being input into a field
by specifying the exact format of the data entry.
IsNull Function - correct answer Checks whether a field has no value.
Join Line - correct answer A line used to create a relationship between 2 tables using
a common field.
Lookup Field - correct answer provides the user with a finite list of values to choose
from in a menu.
Lookup Wizard - correct answer Creates the many of finite values by asking you 6
questions and using your answers to create the options list.
, BIS 245 FINAL EXAM STUDY GUIDE
(LATEST UPDATE 2026-2027) REAL
QUESTIONS AND VERIFIED ANSWERS
100% CORRECT ALREADY {GRADE A} -
DeVry University
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.
(LATEST UPDATE 2026-2027) REAL
QUESTIONS AND VERIFIED ANSWERS
100% CORRECT ALREADY {GRADE A} -
DeVry University
Index - correct answer Reduces the time it takes to run queries and reports
Indexed Property - correct answer Setting that enables quick sorting in primary key
order and quick retrieval based on the primary key
Input Mask - correct answer Enables you to restrict the data being input into a field
by specifying the exact format of the data entry.
IsNull Function - correct answer Checks whether a field has no value.
Join Line - correct answer A line used to create a relationship between 2 tables using
a common field.
Lookup Field - correct answer provides the user with a finite list of values to choose
from in a menu.
Lookup Wizard - correct answer Creates the many of finite values by asking you 6
questions and using your answers to create the options list.
, BIS 245 FINAL EXAM STUDY GUIDE
(LATEST UPDATE 2026-2027) REAL
QUESTIONS AND VERIFIED ANSWERS
100% CORRECT ALREADY {GRADE A} -
DeVry University
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.
