76. In MS Access, which query type is used to create a new table based on query results?
A) Update Query
B) Append Query
C) Make Table Query
D) Delete Query
Answer: C) Make Table Query
77. What is the purpose of the "Relationships" window in MS Access?
A) To enter data
B) To define table links and enforce referential integrity
C) To create queries
D) To create reports
Answer: B) To define table links and enforce referential integrity
78. Which of the following wildcard characters is used to search for any number of characters in MS Access?
A) ?
B) #
C) *
D) &
Answer: C) *
79. In MS Access, which of the following cannot be a primary key?
A) AutoNumber
B) Short Text
C) Long Text (Memo)
D) Number
Answer: C) Long Text (Memo)
80. Which query type is used to modify existing records in MS Access?
A) Select Query
B) Make Table Query
C) Update Query
D) Delete Query
Answer: C) Update Query
81. Which of the following objects stores all data in MS Access?
A) Queries
B) Forms
C) Tables
D) Reports
Answer: C) Tables
82. What is the default file extension of MS Access database files in the newer versions?
A) .mdb
B) .accdb
C) .dbf
D) .xlsx
Answer: B) .accdb
83. Which tool in MS Access helps automate repetitive tasks?
A) Query
B) Macro
C) Form
D) Report
Answer: B) Macro
84. Which section of a report is printed only once at the end?
A) Page Footer
B) Report Header
C) Report Footer
D) Group Header
Answer: C) Report Footer
85. In MS Access, which data type should be used to store large binary objects such as images or files?
A) Short Text
B) OLE Object
C) Hyperlink
D) Number
Answer: B) OLE Object
86. What does the "Column Width" option adjust in a table's Datasheet View?
A) The height of rows
B) The font size of text
C) The width of the columns
D) The number of columns
Answer: C) The width of the columns
87. Which of the following is NOT a valid aggregate function in MS Access?
A) SUM
B) COUNT
C) MERGE
D) AVG
Answer: C) MERGE
88. Which property of a field allows automatic value generation in MS Access?
A) Default Value
B) AutoNumber
C) Lookup
D) Required
Answer: B) AutoNumber
89. Which of the following methods cannot be used to create a table in MS Access?
A) Datasheet View
B) Design View
C) Form View
D) Importing from another source
Answer: C) Form View
90. In MS Access, which of the following is used to set rules for entering valid data in a field?
A) Format Property
B) Lookup Wizard
C) Validation Rule
D) Caption Property
Answer: C) Validation Rule
91. What type of field can be used to store time values in MS Access?
A) Short Text
B) Number
C) Date/Time
D) Memo
Answer: C) Date/Time
92. Which of the following does an Access report NOT contain?
A) Header
B) Detail section
C) Footer
D) Relationships
Answer: D) Relationships
93. Which key combination is used to switch to the Navigation Pane in MS Access?
A) F12
B) F11
C) Ctrl + N
D) Alt + F4
Answer: B) F11
94. What does a parameter query allow users to do in MS Access?
A) View all records without filtering
B) Specify criteria at runtime
C) Modify relationships
D) Add new records
Answer: B) Specify criteria at runtime
95. Which of the following operations can a form NOT perform in MS Access?
A) Data entry
B) Data modification
C) Data deletion
D) Data backup
Answer: D) Data backup
96. Which property is used to specify how a field’s values should be displayed in MS Access?
A) Input Mask
B) Format
C) Default Value
D) Validation Rule
Answer: B) Format
97. In MS Access, what happens when you delete a field from a table?
A) The data in the field is also deleted
B) Only the field name is deleted
C) Relationships are automatically updated
D) The field can be restored later
Answer: A) The data in the field is also deleted
98. Which of the following file formats can be exported from MS Access?
A) PDF
B) Excel
C) Text (CSV)
D) All of the above
Answer: D) All of the above
99. Which control is used to display Yes/No values in a form or report?
A) Combo Box
B) Check Box
C) List Box
D) Text Box
Answer: B) Check Box
100. What is the purpose of a Split Form in MS Access?
A) To split data across two databases
B) To view data in two different layouts simultaneously
C) To divide a report into sections
D) To split a relationship
Answer: B) To view data in two different layouts simultaneously
