51. In MS Access, which key combination is used to save a database object?
A) Ctrl + S
B) Ctrl + P
C) Shift + S
D) Alt + S
Answer: A) Ctrl + S
52. What is the purpose of a foreign key in MS Access?
A) To store unique values
B) To enforce referential integrity
C) To create indexes
D) To automatically generate numbers
Answer: B) To enforce referential integrity
53. Which of the following statements about MS Access relationships is TRUE?
A) A table can have only one relationship
B) A relationship can link multiple tables
C) Relationships do not support referential integrity
D) Relationships can only be created using queries
Answer: B) A relationship can link multiple tables
54. What is the maximum number of characters allowed in an MS Access field name?
A) 32
B) 64
C) 128
D) 255
Answer: B) 64
55. In MS Access, which function is used to calculate the average of values in a field?
A) SUM()
B) AVERAGE()
C) AVG()
D) COUNT()
Answer: C) AVG()
56. Which MS Access object is used to graphically represent data in a structured manner?
A) Report
B) Table
C) Query
D) Macro
Answer: A) Report
57. Which of the following is a valid way to import data into MS Access?
A) XML files
B) Excel files
C) Text files
D) All of the above
Answer: D) All of the above
58. Which view is used to create calculated fields in an MS Access report?
A) Design View
B) Layout View
C) Print Preview
D) Datasheet View
Answer: A) Design View
59. What is the purpose of the "Allow Zero Length" property in MS Access?
A) To allow fields to accept spaces
B) To permit empty strings
C) To store only numeric values
D) To enable foreign keys
Answer: B) To permit empty strings
60. Which of the following can be used to secure an MS Access database?
A) Password protection
B) User-level security
C) Encrypting the database
D) All of the above
Answer: D) All of the above
61. Which feature in MS Access prevents the deletion of a record if it is referenced in another table?
A) Cascading Delete
B) Referential Integrity
C) Primary Key
D) Input Mask
Answer: B) Referential Integrity
62. What does the Totals row in a query allow you to do?
A) Count records
B) Calculate sums
C) Find averages
D) All of the above
Answer: D) All of the above
63. In MS Access, which property ensures that a field always contains a value?
A) Default Value
B) Required
C) Validation Rule
D) Allow Zero Length
Answer: B) Required
64. What is the purpose of a "Crosstab Query" in MS Access?
A) To update records
B) To summarize data
C) To create forms
D) To delete records
Answer: B) To summarize data
65. In MS Access, which view allows you to directly enter records into a form?
A) Form View
B) Layout View
C) Print Preview
D) Design View
Answer: A) Form View
66. What happens when you set a field's "Indexed" property to "Yes (No Duplicates)"?
A) It prevents duplicate values
B) It allows only unique foreign keys
C) It enables referential integrity
D) It speeds up sorting
Answer: A) It prevents duplicate values
67. Which MS Access feature is used to display related data from different tables?
A) Subform
B) Macro
C) Lookup Field
D) Switchboard
Answer: A) Subform
68. In MS Access, what does an Attachment data type allow you to store?
A) Images and documents
B) Only text
C) Only hyperlinks
D) Numeric values
Answer: A) Images and documents
69. Which field property in MS Access can restrict the format of entered data?
A) Validation Rule
B) Format
C) Input Mask
D) Default Value
Answer: C) Input Mask
70. Which type of relationship allows one record in a table to be related to many records in another table?
A) Many-to-Many
B) One-to-One
C) One-to-Many
D) Self-Join
Answer: C) One-to-Many
71. In MS Access, which of the following cannot be used in a calculated field?
A) Aggregate functions
B) Mathematical operators
C) Field references
D) Subqueries
Answer: D) Subqueries
72. Which control type in a form allows users to select from a predefined list of values?
A) Text Box
B) Combo Box
C) Label
D) Hyperlink
Answer: B) Combo Box
73. Which of the following is true about a primary key?
A) It can have duplicate values
B) It must contain a unique value for each record
C) It cannot be used in queries
D) It is always numeric
Answer: B) It must contain a unique value for each record
74. What does the Cascade Update option do in relationships?
A) Automatically updates child records when the primary key changes
B) Deletes related records when the primary key is deleted
C) Prevents updates on related records
D) Removes duplicate records
Answer: A) Automatically updates child records when the primary key changes
75. Which feature in MS Access allows you to visually create SQL queries without writing code?
A) SQL View
B) Query Design View
C) Expression Builder
D) Report Wizard
Answer: B) Query Design View
