INTRODUCTION TO COMPUTERS TEST WEEK 3
WRITTEN REVIEW (MICROSOFT ACCESS) 2025/2026
COMPLETE QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES || 100%
GUARANTEED PASS <LATEST VERSION>
1. What is Microsoft Access primarily used for?
A) Creating spreadsheets and performing complex calculations
B) Designing presentations with animations
C) ✔ Creating and managing relational databases
D) Writing and debugging code
2. The fundamental building block of an Access database where data is stored is
called a:
A) Form
B) Query
C) ✔ Table
D) Report
3. In a database table, a column that uniquely identifies each record is known as
the:
A) Foreign Key
B) ✔ Primary Key
C) Index Key
D) Main Key
4. Which Access object provides an easy-to-use interface for entering,
modifying, and viewing data from a table?
A) Table
B) Query
,C) ✔ Form
D) Macro
5. A Query in Access is used to:
A) Print data in a formatted layout
B) ✔ Retrieve, filter, and analyze data from one or more tables
C) Create a graphical user interface for the database
D) Store the actual data
6. Which object in Access is designed to format, calculate, and present data for
printing or on-screen viewing?
A) Form
B) Query
C) Module
D) ✔ Report
7. A "Record" in an Access table is equivalent to a:
A) Column
B) ✔ Row
C) Cell
D) Field
8. Which data type should be used for a field that will store monetary values?
A) Number
B) Text
C) ✔ Currency
D) Date/Time
9. The "Number" data type is NOT suitable for which of the following?
A) Storing a person's age
B) Storing a product quantity
C) ✔ Storing a phone number with hyphens (e.g., 555-1234)
D) Storing a student's test score
, 10. Which data type allows you to store a web address that can be clicked to
open a browser?
A) Text
B) Memo
C) ✔ Hyperlink
D) OLE Object
11. The "Required" field property, when set to "Yes," means:
A) The field must contain a unique value
B) The field must be a primary key
C) ✔ The field cannot be left empty
D) The field must be a number
12. What is the purpose of a "Lookup Field"?
A) To perform complex mathematical calculations
B) ✔ To create a list of choices from which a user can select a value
C) To automatically generate a primary key
D) To link two databases together
13. In the Relationships window, the "∞" symbol indicates:
A) The primary key side of the relationship
B) ✔ The "many" side of a one-to-many relationship
C) A one-to-one relationship
D) An invalid relationship
14. Referential Integrity ensures that:
A) All data entered is spelled correctly
B) ✔ You cannot enter a value in the foreign key field of a related table that
doesn't exist in the primary key of the parent table
C) Every table has a primary key
D) Queries run faster
15. If you delete a record from a primary table and have "Cascade Delete
Related Records" enabled, what happens?
A) The deletion is cancelled.
WRITTEN REVIEW (MICROSOFT ACCESS) 2025/2026
COMPLETE QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES || 100%
GUARANTEED PASS <LATEST VERSION>
1. What is Microsoft Access primarily used for?
A) Creating spreadsheets and performing complex calculations
B) Designing presentations with animations
C) ✔ Creating and managing relational databases
D) Writing and debugging code
2. The fundamental building block of an Access database where data is stored is
called a:
A) Form
B) Query
C) ✔ Table
D) Report
3. In a database table, a column that uniquely identifies each record is known as
the:
A) Foreign Key
B) ✔ Primary Key
C) Index Key
D) Main Key
4. Which Access object provides an easy-to-use interface for entering,
modifying, and viewing data from a table?
A) Table
B) Query
,C) ✔ Form
D) Macro
5. A Query in Access is used to:
A) Print data in a formatted layout
B) ✔ Retrieve, filter, and analyze data from one or more tables
C) Create a graphical user interface for the database
D) Store the actual data
6. Which object in Access is designed to format, calculate, and present data for
printing or on-screen viewing?
A) Form
B) Query
C) Module
D) ✔ Report
7. A "Record" in an Access table is equivalent to a:
A) Column
B) ✔ Row
C) Cell
D) Field
8. Which data type should be used for a field that will store monetary values?
A) Number
B) Text
C) ✔ Currency
D) Date/Time
9. The "Number" data type is NOT suitable for which of the following?
A) Storing a person's age
B) Storing a product quantity
C) ✔ Storing a phone number with hyphens (e.g., 555-1234)
D) Storing a student's test score
, 10. Which data type allows you to store a web address that can be clicked to
open a browser?
A) Text
B) Memo
C) ✔ Hyperlink
D) OLE Object
11. The "Required" field property, when set to "Yes," means:
A) The field must contain a unique value
B) The field must be a primary key
C) ✔ The field cannot be left empty
D) The field must be a number
12. What is the purpose of a "Lookup Field"?
A) To perform complex mathematical calculations
B) ✔ To create a list of choices from which a user can select a value
C) To automatically generate a primary key
D) To link two databases together
13. In the Relationships window, the "∞" symbol indicates:
A) The primary key side of the relationship
B) ✔ The "many" side of a one-to-many relationship
C) A one-to-one relationship
D) An invalid relationship
14. Referential Integrity ensures that:
A) All data entered is spelled correctly
B) ✔ You cannot enter a value in the foreign key field of a related table that
doesn't exist in the primary key of the parent table
C) Every table has a primary key
D) Queries run faster
15. If you delete a record from a primary table and have "Cascade Delete
Related Records" enabled, what happens?
A) The deletion is cancelled.
