26. In MS Access, what is the maximum number of characters allowed in a Short Text field?
A) 255
B) 512
C) 1024
D) 4096
Answer: A) 255
27. Which of the following is NOT a valid relationship type in MS Access?
A) One-to-One
B) One-to-Many
C) Many-to-Many
D) One-to-All
Answer: D) One-to-All
28. Which feature in MS Access helps to find duplicate records in a table?
A) Find Duplicates Query
B) Append Query
C) Find Unmatched Query
D) Delete Query
Answer: A) Find Duplicates Query
29. What does the Compact and Repair Database tool do?
A) Deletes unwanted records
B) Fixes broken relationships
C) Reduces database size and fixes corruption
D) Updates linked tables
Answer: C) Reduces database size and fixes corruption
30. In MS Access, which view is used to enter data directly into a table?
A) Design View
B) Form View
C) Datasheet View
D) SQL View
Answer: C) Datasheet View
31. What is the purpose of an Input Mask in MS Access?
A) To prevent unauthorized access
B) To control data entry format
C) To store passwords
D) To sort records
Answer: B) To control data entry format
32. Which of the following functions can be used to get the current date in MS Access?
A) NOW()
B) DATE()
C) TODAY()
D) CURRENT_DATE()
Answer: A) NOW()
33. In MS Access, which of the following is used to create user-friendly interfaces for data entry?
A) Queries
B) Forms
C) Reports
D) Tables
Answer: B) Forms
34. Which MS Access feature allows you to restrict data entry based on predefined criteria?
A) Validation Rule
B) Primary Key
C) Relationship
D) AutoNumber
Answer: A) Validation Rule
35. What is the maximum number of characters allowed in a Long Text (Memo) field in MS Access?
A) 255
B) 32,768
C) 65,536
D) 1,048,576
Answer: B) 32,768
36. What type of query is used to delete records in MS Access?
A) Delete Query
B) Update Query
C) Append Query
D) Crosstab Query
Answer: A) Delete Query
37. In MS Access, which of the following types of queries summarizes data?
A) Select Query
B) Crosstab Query
C) Action Query
D) Make Table Query
Answer: B) Crosstab Query
38. What is a Lookup Field used for in MS Access?
A) To perform calculations
B) To create dropdown selections
C) To store hyperlinks
D) To generate reports
Answer: B) To create dropdown selections
39. In MS Access, which of the following is NOT a valid join type?
A) Inner Join
B) Outer Join
C) Cross Join
D) Middle Join
Answer: D) Middle Join
40. Which property in a field ensures that values entered are unique?
A) Required
B) Default Value
C) Indexed (No Duplicates)
D) Input Mask
Answer: C) Indexed (No Duplicates)
41. What is the purpose of the AutoNumber data type in MS Access?
A) To create random values
B) To store text data
C) To generate unique sequential numbers
D) To store currency values
Answer: C) To generate unique sequential numbers
42. Which key is used to switch between Design View and Datasheet View in MS Access?
A) F5
B) F6
C) F11
D) F2
Answer: B) F6
43. Which section of an Access report is repeated on each page?
A) Detail
B) Report Header
C) Page Header
D) Group Footer
Answer: C) Page Header
44. In MS Access, which data type is used to store hyperlinks?
A) Short Text
B) Hyperlink
C) Memo
D) Attachment
Answer: B) Hyperlink
45. What is the default sorting order in MS Access?
A) Ascending
B) Descending
C) Random
D) No default order
Answer: A) Ascending
46. What is the main purpose of a Switchboard in MS Access?
A) To store data
B) To navigate through the database
C) To write SQL queries
D) To create reports
Answer: B) To navigate through the database
47. In MS Access, which object provides a user-friendly way to display and print data?
A) Query
B) Report
C) Table
D) Macro
Answer: B) Report
48. Which of the following is NOT a valid MS Access data type?
A) Text
B) Date/Time
C) Image
D) Currency
Answer: C) Image
49. What does the Lookup Wizard do in MS Access?
A) Converts tables to queries
B) Creates relationships automatically
C) Creates a field that retrieves values from another table
D) Creates forms with automatic lookup
Answer: C) Creates a field that retrieves values from another table
50. In MS Access, which command is used to import data from an Excel file?
A) Get External Data
B) Import Wizard
C) Export Data
D) Linked Table Manager
Answer: A) Get External Data
