MS Access – Database Management

1. : In MS Access, a database is a collection of related __________.
(A) Documents
(B) Tables, Queries, Forms, and Reports
(C) Charts and Slides
(D) Worksheets

2. : Which object in MS Access is used to store raw data in rows and columns?
(A) Query
(B) Form
(C) Table
(D) Report

3. : Which MS Access object is used to retrieve and filter data based on specific conditions?
(A) Table
(B) Query
(C) Form
(D) Report

4. : Which MS Access object provides a user-friendly interface for data entry and editing?
(A) Form
(B) Report
(C) Table
(D) Query

5. : Which object in MS Access is primarily used to present data in a printable format?
(A) Form
(B) Report
(C) Query
(D) Table

6. : In MS Access, what is a Primary Key?
(A) A field that stores duplicate values
(B) A field that uniquely identifies each record in a table
(C) A key used to open the database
(D) A backup of the database

7. : Which data type in MS Access is best suited for storing long text such as descriptions?
(A) Short Text
(B) Long Text (Memo)
(C) Number
(D) Date/Time

8. : Which relationship type ensures that each record in one table matches only one record in another table?
(A) One-to-Many
(B) Many-to-Many
(C) One-to-One
(D) Self-Join

9. : Which view in MS Access is used to design and structure a table?
(A) Datasheet View
(B) Design View
(C) Form View
(D) Report View

10. : What is the default file extension for an MS Access database (2016 and later)?
(A) .mdb
(B) .dbf
(C) .accdb
(D) .db