ITE 152 EXAM 3 ACTUAL EXAM 2026 | ALL QUESTIONS AND CORRECT ANSWERS |
ALREADY GRADED A+ | LATEST EXAM
Question 1
Sawyer is looking at a table of students in his class, but it seems like the list is way too short.
What is the most likely problem?
A) The table is missing a primary key.
B) The table is sorted.
C) The table is filtered.
D) The table has been deleted.
E) The table is in Design View.
Correct Answer: C) The table is filtered.
Rationale: A filter is a tool used in databases to hide records that do not meet specific
criteria. If a list appears "too short," it is usually because a filter has been applied, causing
Access to display only a subset of the total records available in the table.
Question 2
Xavier is designing a Students table that will continue to track students even after they have
completed their programs. Which of the following fields would work best with the Yes/No data
type?
A) Employer
B) Graduated
/ GPA
D) Major
E) StudentID
Correct Answer: B) Graduated
Rationale: The Yes/No data type (also known as a Boolean) is used for fields that can only
have one of two possible values. Since a student has either graduated or they haven't, this
field is a perfect candidate for a Yes/No toggle or checkbox.
Question 3
"One disadvantage of computerized databases is that they limit your ability to arrange
information." Is this statement true or false?
A) True
B) False
C) Only true for Microsoft Access
D) Only true for flat-file databases
E) None of the above
Correct Answer: B) False
Rationale: Computerized databases actually increase your ability to arrange information.
They allow users to sort, filter, and group data in thousands of different ways instantly,
whereas paper-based systems are extremely limited in how they can be rearranged.
, 2
Question 4
A database is a collection of related information, but a database management system (DBMS) is
a type of software program.
A) True
B) False
C) Both are types of hardware
D) A database is a type of software
E) A DBMS is a collection of information
Correct Answer: A) True
Rationale: This is a fundamental distinction. The "database" refers to the actual data (the
files or information), while the "DBMS" (like Microsoft Access, Oracle, or SQL Server) is
the software tool used to create, maintain, and manipulate that data.
Question 5
A database is an organized collection of information.
A) True
B) False
C) Only if it uses SQL
D) Only if it is on a cloud server
E) None of the above
Correct Answer: A) True
Rationale: The defining characteristic of a database, as opposed to a simple list or a pile of
papers, is that the information is "organized." This organization (using tables, rows, and
columns) allows for efficient retrieval and analysis of data.
Question 6
What are the columns in a Microsoft Access table called?
A) Rows
B) Fields
C) Records
D) Columns
E) Cells
Correct Answer: B) Fields
Rationale: In database terminology, columns are referred to as "Fields." Each field
represents a specific category of information (e.g., "First Name" or "Phone Number") that
is collected for every entry in the table.
Question 7
Ibraheem works for a music store. Which of the following tables will give him the company
contact information he needs to place a custom order for a guitar?
A) Inventory
, 3
B) Employees
C) Customers
D) Vendors
E) Sales
Correct Answer: D) Vendors
Rationale: A "Vendor" table stores information about the suppliers or companies from
which a business purchases its stock. To place an order for new equipment, Ibraheem needs
to access the Vendor table to find the appropriate contact details.
Question 8
What does the acronym SQL stand for in the context of databases?
A) Stated question language
B) Structured query language
C) System query lingo
D) Status query language
E) Standardized quantitative logic
Correct Answer: B) Structured query language
Rationale: SQL is the international standard language used to communicate with relational
databases. It allows users to create tables, insert data, and run complex queries to extract
specific information.
Question 9
Which of the following is LEAST likely to be a field in a "Customers" table?
A) LastName
B) Address
C) EmploymentDate
D) PhoneNumber
E) EmailAddress
Correct Answer: C) EmploymentDate
Rationale: "EmploymentDate" is data related to an employee, not a customer. While names,
addresses, and phone numbers are standard for tracking customer relationships, an
employment date would belong in an "Employees" or "HR" table.
Question 10
In a relational database, a "Relationship" is typically created between how many tables?
A) Two
B) Any number
C) Three
D) One
E) Zero
Correct Answer: A) Two
, 4
Rationale: A relationship in Access is a connection between two tables based on a common
field (usually a primary key in one table and a foreign key in another). This allows data
from both tables to be combined in queries and reports.
Question 11
What is the best definition of a "Query" in a database?
A) A question you ask a table
B) A question you ask a record
C) A question you ask a database
D) A question you ask a field
E) A way to delete the database
Correct Answer: C) A question you ask a database
Rationale: A query is a request for data results from your database. It allows you to "ask"
the database to show you specific records that meet certain criteria (e.g., "Show me all
customers who live in Virginia").
Question 12
A computerized database can store millions of telephone numbers.
A) True
B) False
C) Only if it is stored on a mainframe
D) Only if the data is encrypted
E) Databases are limited to 1,000 records
Correct Answer: A) True
Rationale: One of the primary advantages of computerized databases over manual systems
is scalability. Modern DBMS software can easily manage millions, or even billions, of
records with high speed and reliability.
Question 13
Which data type would be best suited to a field that lists customer email addresses?
A) Hyperlink
B) AutoNumber
C) Date/Time
D) Number
E) Attachment
Correct Answer: A) Hyperlink
Rationale: The Hyperlink data type is specifically designed for web addresses and email
addresses. When clicked in Access, it will automatically trigger the default email client to
start a new message to that address.
ALREADY GRADED A+ | LATEST EXAM
Question 1
Sawyer is looking at a table of students in his class, but it seems like the list is way too short.
What is the most likely problem?
A) The table is missing a primary key.
B) The table is sorted.
C) The table is filtered.
D) The table has been deleted.
E) The table is in Design View.
Correct Answer: C) The table is filtered.
Rationale: A filter is a tool used in databases to hide records that do not meet specific
criteria. If a list appears "too short," it is usually because a filter has been applied, causing
Access to display only a subset of the total records available in the table.
Question 2
Xavier is designing a Students table that will continue to track students even after they have
completed their programs. Which of the following fields would work best with the Yes/No data
type?
A) Employer
B) Graduated
/ GPA
D) Major
E) StudentID
Correct Answer: B) Graduated
Rationale: The Yes/No data type (also known as a Boolean) is used for fields that can only
have one of two possible values. Since a student has either graduated or they haven't, this
field is a perfect candidate for a Yes/No toggle or checkbox.
Question 3
"One disadvantage of computerized databases is that they limit your ability to arrange
information." Is this statement true or false?
A) True
B) False
C) Only true for Microsoft Access
D) Only true for flat-file databases
E) None of the above
Correct Answer: B) False
Rationale: Computerized databases actually increase your ability to arrange information.
They allow users to sort, filter, and group data in thousands of different ways instantly,
whereas paper-based systems are extremely limited in how they can be rearranged.
, 2
Question 4
A database is a collection of related information, but a database management system (DBMS) is
a type of software program.
A) True
B) False
C) Both are types of hardware
D) A database is a type of software
E) A DBMS is a collection of information
Correct Answer: A) True
Rationale: This is a fundamental distinction. The "database" refers to the actual data (the
files or information), while the "DBMS" (like Microsoft Access, Oracle, or SQL Server) is
the software tool used to create, maintain, and manipulate that data.
Question 5
A database is an organized collection of information.
A) True
B) False
C) Only if it uses SQL
D) Only if it is on a cloud server
E) None of the above
Correct Answer: A) True
Rationale: The defining characteristic of a database, as opposed to a simple list or a pile of
papers, is that the information is "organized." This organization (using tables, rows, and
columns) allows for efficient retrieval and analysis of data.
Question 6
What are the columns in a Microsoft Access table called?
A) Rows
B) Fields
C) Records
D) Columns
E) Cells
Correct Answer: B) Fields
Rationale: In database terminology, columns are referred to as "Fields." Each field
represents a specific category of information (e.g., "First Name" or "Phone Number") that
is collected for every entry in the table.
Question 7
Ibraheem works for a music store. Which of the following tables will give him the company
contact information he needs to place a custom order for a guitar?
A) Inventory
, 3
B) Employees
C) Customers
D) Vendors
E) Sales
Correct Answer: D) Vendors
Rationale: A "Vendor" table stores information about the suppliers or companies from
which a business purchases its stock. To place an order for new equipment, Ibraheem needs
to access the Vendor table to find the appropriate contact details.
Question 8
What does the acronym SQL stand for in the context of databases?
A) Stated question language
B) Structured query language
C) System query lingo
D) Status query language
E) Standardized quantitative logic
Correct Answer: B) Structured query language
Rationale: SQL is the international standard language used to communicate with relational
databases. It allows users to create tables, insert data, and run complex queries to extract
specific information.
Question 9
Which of the following is LEAST likely to be a field in a "Customers" table?
A) LastName
B) Address
C) EmploymentDate
D) PhoneNumber
E) EmailAddress
Correct Answer: C) EmploymentDate
Rationale: "EmploymentDate" is data related to an employee, not a customer. While names,
addresses, and phone numbers are standard for tracking customer relationships, an
employment date would belong in an "Employees" or "HR" table.
Question 10
In a relational database, a "Relationship" is typically created between how many tables?
A) Two
B) Any number
C) Three
D) One
E) Zero
Correct Answer: A) Two
, 4
Rationale: A relationship in Access is a connection between two tables based on a common
field (usually a primary key in one table and a foreign key in another). This allows data
from both tables to be combined in queries and reports.
Question 11
What is the best definition of a "Query" in a database?
A) A question you ask a table
B) A question you ask a record
C) A question you ask a database
D) A question you ask a field
E) A way to delete the database
Correct Answer: C) A question you ask a database
Rationale: A query is a request for data results from your database. It allows you to "ask"
the database to show you specific records that meet certain criteria (e.g., "Show me all
customers who live in Virginia").
Question 12
A computerized database can store millions of telephone numbers.
A) True
B) False
C) Only if it is stored on a mainframe
D) Only if the data is encrypted
E) Databases are limited to 1,000 records
Correct Answer: A) True
Rationale: One of the primary advantages of computerized databases over manual systems
is scalability. Modern DBMS software can easily manage millions, or even billions, of
records with high speed and reliability.
Question 13
Which data type would be best suited to a field that lists customer email addresses?
A) Hyperlink
B) AutoNumber
C) Date/Time
D) Number
E) Attachment
Correct Answer: A) Hyperlink
Rationale: The Hyperlink data type is specifically designed for web addresses and email
addresses. When clicked in Access, it will automatically trigger the default email client to
start a new message to that address.
