T4Tutorials .PK

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




Exit mobile version