101. In MS Access, what type of relationship exists when one record in Table A corresponds to exactly one record in Table B?
A) One-to-Many
B) Many-to-Many
C) One-to-One
D) Self-Join
Answer: C) One-to-One
102. Which action query is used to remove records from a table based on specified criteria?
A) Update Query
B) Delete Query
C) Append Query
D) Make Table Query
Answer: B) Delete Query
103. In MS Access, which section of a report repeats for each record in the dataset?
A) Report Footer
B) Detail Section
C) Page Footer
D) Report Header
Answer: B) Detail Section
104. What is the maximum number of characters allowed in an MS Access Short Text field?
A) 64
B) 128
C) 255
D) Unlimited
Answer: C) 255
105. Which of the following is a valid MS Access macro action?
A) OpenQuery
B) DeleteDatabase
C) DropTable
D) MergeData
Answer: A) OpenQuery
106. Which object in MS Access allows users to input and manipulate data easily?
A) Table
B) Query
C) Form
D) Report
Answer: C) Form
107. Which MS Access feature can be used to automate a sequence of tasks?
A) Macros
B) Queries
C) Tables
D) Reports
Answer: A) Macros
108. In MS Access, which tool is used to analyze table structures and detect inconsistencies?
A) Table Analyzer
B) Report Wizard
C) Macro Recorder
D) Expression Builder
Answer: A) Table Analyzer
109. What happens if referential integrity is enabled and you try to delete a parent record?
A) The record is deleted along with child records
B) MS Access prevents deletion if related child records exist
C) Only the parent record is deleted
D) All records are removed
Answer: B) MS Access prevents deletion if related child records exist
110. Which function is used to extract the year from a Date/Time field in MS Access?
A) DATEPART()
B) YEAR()
C) GETYEAR()
D) EXTRACT()
Answer: B) YEAR()
111. What is the primary purpose of a lookup field in MS Access?
A) To validate user input
B) To restrict data entry
C) To display values from another table
D) To store file attachments
Answer: C) To display values from another table
112. In MS Access, what does the "Indexed" property of a field do?
A) Ensures unique values
B) Speeds up searches
C) Prevents duplicate entries
D) All of the above
Answer: D) All of the above
113. What happens when you run an append query in MS Access?
A) It adds new records to an existing table
B) It deletes records from a table
C) It creates a new table
D) It updates records in a table
Answer: A) It adds new records to an existing table
114. Which key is used to navigate to the next record in MS Access forms?
A) Tab
B) Enter
C) Arrow keys
D) F5
Answer: C) Arrow keys
115. What type of form layout arranges labels and controls in a stacked vertical format?
A) Tabular
B) Stacked
C) Datasheet
D) Continuous
Answer: B) Stacked
116. In MS Access, how can you prevent users from entering duplicate values in a field?
A) Set the field as Required
B) Use a Validation Rule
C) Set the field as Primary Key
D) Apply a Default Value
Answer: C) Set the field as Primary Key
117. What is the primary function of a report in MS Access?
A) To modify table structure
B) To display and summarize data in a printable format
C) To update records
D) To store data
Answer: B) To display and summarize data in a printable format
118. Which command is used to export an MS Access table to an Excel file?
A) Export to Excel
B) Save As
C) Send To
D) External Data -> Export
Answer: D) External Data -> Export
119. In MS Access, which statement about relationships is true?
A) A table cannot have multiple relationships
B) Relationships ensure data consistency
C) Relationships are only needed for reports
D) Queries cannot use relationships
Answer: B) Relationships ensure data consistency
120. How do you rename an existing table in MS Access?
A) Right-click the table name and select "Rename"
B) Use the Design View
C) Modify through SQL
D) Press F2 in Datasheet View
Answer: A) Right-click the table name and select "Rename"
121. In an MS Access form, which control type is best suited for displaying a drop-down list of options?
A) Combo Box
B) Text Box
C) Option Group
D) Subform
Answer: A) Combo Box
122. What does the "Compact & Repair" utility in MS Access do?
A) Deletes duplicate records
B) Fixes database errors and reduces file size
C) Restores deleted records
D) Converts files to a new format
Answer: B) Fixes database errors and reduces file size
123. Which MS Access feature allows for data entry in a structured manner?
A) Tables
B) Queries
C) Forms
D) Reports
Answer: C) Forms
124. Which action CANNOT be performed directly within a query in MS Access?
A) Inserting records
B) Deleting records
C) Sorting data
D) Calculating totals
Answer: A) Inserting records
125. When designing an MS Access form, what is the purpose of the "Tab Order" feature?
A) To set the color of fields
B) To define the order of data entry fields
C) To link forms to reports
D) To set validation rules
Answer: B) To define the order of data entry fields
