BIS 245 CASE STUDY GUIDE DATABASE ESSENTIALS FOR BUSINESS WITH LAB EXAM 2026 QUESTIONS LATEST VERSION QUESTIONS AND ANSWERS

Page 1 of 70


BIS 245 CASE STUDY GUIDE DATABASE ESSENTIALS FOR BUSINESS
WITH LAB EXAM 2026 QUESTIONS LATEST VERSION QUESTIONS
AND ANSWERS




BIS 245 CASE STUDY GUIDE EXAM
Database Essentials for Business with Lab




SECTION 1: DATABASE FUNDAMENTALS & CONCEPTS (Questions 1-50)


Question 1
What is a relational database?
A) A database that stores data in a single table
B) A database that stores data in multiple tables linked by common fields
C) A database that only stores text data
D) A database that cannot be queried
Rationale: The correct answer is B. A relational database organizes data into multiple tables
that are linked by common fields (keys) to reduce redundancy and improve data integrity.
This structure allows for complex queries across related data.


Question 2
Which of the following is the smallest data element in a database table?
A) Record
B) Field
C) Table
D) Database
Rationale: The correct answer is B. A field represents the smallest data element in a table,
such as a first name, last name, address, or phone number. Fields are organized into records
(rows), which make up tables.

, Page 2 of 70


Question 3
A group of related fields representing one entity (such as data for one person) is called
a:
A) Field
B) Record
C) Table
D) Database
Rationale: The correct answer is B. A record is a group of related fields representing one
entity, such as data for one person, place, event, or concept. Records are stored as rows in
database tables.


Question 4
An object used to store and organize data in a series of records (rows) and fields
(columns) is called a:
A) Form
B) Query
C) Table
D) Report
Rationale: The correct answer is C. A table is the foundation of every database, storing data
in a series of records (rows) with each record made up of a number of fields (columns).


Question 5
A collection of data organized as meaningful information that can be accessed,
managed, stored, queried, sorted, and reported is called a:
A) Table
B) Record
C) Database
D) Field
Rationale: The correct answer is C. A database is a collection of data organized as
meaningful information that can be accessed, managed, stored, queried, sorted, and reported.


Question 6
What is the primary purpose of a Database Management System (DBMS)?
A) To create documents and spreadsheets

, Page 3 of 70


B) To provide tools to create, maintain, and use a database
C) To design websites
D) To manage network connections
Rationale: The correct answer is B. A Database Management System (DBMS) is a software
system that provides the tools needed to create, maintain, and use a database.


Question 7
Which database object is used to add, edit, or delete table data?
A) Query
B) Report
C) Form
D) Macro
Rationale: The correct answer is C. Forms are database objects used to add, edit, or delete
table data. They provide a user-friendly interface for data entry and modification.


Question 8
Which database object contains professional-looking formatted information from
underlying tables or queries?
A) Form
B) Report
C) Table
D) Macro
Rationale: The correct answer is B. Reports are objects that contain professional-looking
formatted information from underlying tables or queries. They are used for printing and
presenting data.


Question 9
What type of database object is used to automate tasks in Access?
A) Module
B) Query
C) Macro
D) Form
Rationale: The correct answer is C. Macros are a series of actions that can be programmed to
automate tasks in a database. They help streamline repetitive operations.

, Page 4 of 70



Question 10
Which database object is written using Visual Basic for Applications (VBA) and adds
functionality to the database?
A) Macro
B) Module
C) Query
D) Report
Rationale: The correct answer is B. Modules are objects written using Visual Basic for
Applications (VBA) that add custom functionality to a database.


Question 11
What is the industry-standard language for defining, manipulating, and retrieving data
in a database?
A) HTML
B) XML
C) SQL
D) Java
Rationale: The correct answer is C. Structured Query Language (SQL) is the industry-
standard language for defining, manipulating, and retrieving data in a database. It is essential
for querying relational databases.


Question 12
In the relational database model, what term describes the connection between two
tables?
A) Entity
B) Attribute
C) Relationship
D) Record
Rationale: The correct answer is C. A relationship describes the connection between two
tables in a relational database. Relationships are established through common fields (keys).


Question 13
A primary key made of 2 or more fields is called a: