1. What type of database is MS Access?
A) Hierarchical
B) Relational
C) Network
D) Object-oriented
Answer: B) Relational
2. In MS Access, a table consists of ____ and ____.
A) Rows and Columns
B) Queries and Reports
C) Macros and Modules
D) Forms and Controls
Answer: A) Rows and Columns
3. Which data type is suitable for storing large text in MS Access?
A) Text
B) Memo
C) Number
D) Currency
Answer: B) Memo
4. What is the primary key used for in a table?
A) To create relationships
B) To uniquely identify each record
C) To store numeric data
D) To provide security
Answer: B) To uniquely identify each record
5. In MS Access, which view allows you to define and modify the structure of a table?
A) Datasheet View
B) Form View
C) Design View
D) PivotTable View
Answer: C) Design View
6. What does a query in MS Access do?
A) Stores data
B) Modifies table structure
C) Retrieves specific data
D) Creates forms
Answer: C) Retrieves specific data
7. Which of the following is NOT an object in MS Access?
A) Tables
B) Forms
C) Worksheets
D) Reports
Answer: C) Worksheets
8. What is the default file extension for an MS Access database?
A) .mdb
B) .accdb
C) .dbf
D) .xlsx
Answer: B) .accdb
9. Which of the following is used to automate repetitive tasks in MS Access?
A) Forms
B) Queries
C) Macros
D) Modules
Answer: C) Macros
10. The process of organizing data to minimize redundancy is called ____.
A) Sorting
B) Filtering
C) Normalization
D) Aggregation
Answer: C) Normalization
11. What is a form used for in MS Access?
A) Data analysis
B) Entering and modifying data
C) Storing data
D) Generating reports
Answer: B) Entering and modifying data
12. Which query type is used to modify existing records in MS Access?
A) Select Query
B) Append Query
C) Update Query
D) Crosstab Query
Answer: C) Update Query
13. The relationship between two tables can be created using ____.
A) Reports
B) Forms
C) Queries
D) Relationships window
Answer: D) Relationships window
14. Which data type stores Yes/No values in MS Access?
A) Text
B) Boolean
C) Binary
D) Yes/No
Answer: D) Yes/No
15. What is the purpose of the Report object in MS Access?
A) To enter data
B) To generate formatted printouts of data
C) To store large amounts of text
D) To perform calculations
Answer: B) To generate formatted printouts of data
16. What feature allows you to enforce data integrity between related tables?
A) Primary Key
B) Referential Integrity
C) Foreign Key
D) Data Validation
Answer: B) Referential Integrity
17. A field that uniquely identifies each record in a table is called ____.
A) Foreign Key
B) Unique Field
C) Primary Key
D) Index
Answer: C) Primary Key
18. Which MS Access object is best for printing data in a structured format?
A) Form
B) Table
C) Report
D) Query
Answer: C) Report
19. Which statement is used in queries to filter records based on criteria?
A) SELECT
B) FILTER
C) WHERE
D) ORDER BY
Answer: C) WHERE
20. What function is used to find the total number of records in a query?
A) SUM()
B) COUNT()
C) AVG()
D) MAX()
Answer: B) COUNT()
21. What key combination is used to run a query in MS Access?
A) Ctrl + Q
B) F5
C) Alt + Enter
D) Shift + Enter
Answer: B) F5
22. Which section of a report in MS Access prints once at the beginning of the report?
A) Page Header
B) Report Header
C) Detail Section
D) Footer
Answer: B) Report Header
23. In which object can you create calculated fields in MS Access?
A) Table
B) Query
C) Form
D) Report
Answer: B) Query
24. Which option allows you to create a backup of your MS Access database?
A) Export
B) Save As
C) Compact and Repair
D) Backup Database
Answer: D) Backup Database
25. Which field property in MS Access helps to ensure that a value is entered in a field?
A) Required
B) Default Value
C) Validation Rule
D) Input Mask
Answer: A) Required
