डेटाबेस म्यानेजमेन्ट सिस्टम (DBMS) अन्तर्गत लोकसेवाले MS Access बाट धेरै प्रश्नहरू सोध्ने गर्छ। डेटाबेसका नियमहरू बुझ्नका लागि यी ५० प्रश्नहरू उपयोगी छन्।
### MS Access - Top 50 MCQs
**१. MS Access is a:**
Answer: Relational Database Management System (RDBMS)
**२. What is the default file extension of MS Access 2007 and above files?**
Answer: .accdb
**३. Which data type in MS Access is used to store long text up to 65,535 characters?**
Answer: Memo (Long Text)
**४. In MS Access, rows of a table are called:**
Answer: Records
**५. In MS Access, columns of a table are called:**
Answer: Fields
**६. Which object in MS Access is used to enter or view data in a user-friendly layout?**
Answer: Form
**७. Primary key does not allow:**
Answer: Null values or Duplicate values
**८. What is the default size of Text data type in MS Access?**
Answer: 255 characters
**९. Which feature helps to prevent invalid data from being entered into a table field?**
Answer: Validation Rule
**१०. What is a key that links two tables together called?**
Answer: Foreign Key
**११. Which query is used to add new records to an existing table?**
Answer: Append Query
**१२. What is the shortcut key to save the current database object?**
Answer: Ctrl + S
**१३. Ole Object data type in MS Access can store:**
Answer: Images, Audio, Video, and documents
**१४. What is the default data type assigned to a new field in MS Access?**
Answer: Short Text
**१५. Which wizard is used to create a link to another table in MS Access?**
Answer: Lookup Wizard
**१६. To retrieve data based on specific criteria, we use:**
Answer: Select Query
**१७. What does SQL stand for in database terminology?**
Answer: Structured Query Language
**१८. Which view is used to define the structure of a table (Field names and data types)?**
Answer: Design View
**१९. Which view is used to enter or edit data directly into a table grid?**
Answer: Datasheet View
**२०. In MS Access, Yes/No data type takes how many bytes of storage?**
Answer: 1 bit
**२१. Which property is used to format the way data is displayed in a field?**
Answer: Format Property
**२२. To ensure data consistency across related tables, we enable:**
Answer: Referential Integrity
**२३. What is the maximum length of a field name in MS Access?**
Answer: 64 characters
**२४. Can a table in MS Access have multiple primary keys?**
Answer: No (Only one primary key per table)
**२५. Wildcard character '*' in MS Access query matches:**
Answer: Any number of characters
**२६. Which query makes changes to or moves many records in just one operation?**
Answer: Action Query
**२७. What type of field automatically generates a unique number for each new record?**
Answer: AutoNumber
**२८. Input Mask property is used for:**
Answer: Setting a specific pattern for data entry (like phone numbers)
**२९. What is the shortcut key to open an existing database?**
Answer: Ctrl + O
**३०. Reports in MS Access are used to:**
Answer: Present and print data in an organized format
**३१. Which of the following is NOT a valid data type in MS Access?**
Answer: Picture
**३२. The expression builder is a built-in tool that allows you to create:**
Answer: Formulas or Expressions
**३३. To delete a table or query object, which shortcut key is used?**
Answer: Delete key
**३४. Which database object reduces data redundancy?**
Answer: Table Relationships
**३५. What is the shortcut key to switch between Design view and Datasheet view?**
Answer: Ctrl + . (Period)
**३६. In MS Access, "Hyperlink" data type can store:**
Answer: Web addresses or email IDs
**३७. Which property allows you to set a default value for a field automatically?**
Answer: Default Value Property
**३८. What is the maximum number of characters allowed in a field name?**
Answer: 64 characters
**३९. Which query is used to delete records from one or more tables?**
Answer: Delete Query
**४०. Cascade Delete Related Records option ensures:**
Answer: Related records are deleted automatically when the parent record is deleted
**४१. In MS Access, a database consists of:**
Answer: Tables, Queries, Forms, Reports (All of the above)
**४२. Which section of a report appears at the top of every page?**
Answer: Page Header
**४३. Which data type is best suited for storing monetary values?**
Answer: Currency
**४४. To speed up data retrieval and sorting, we use:**
Answer: Indexing
**४५. What is the default field size for a Number data type in Access?**
Answer: Long Integer
**४६. Which validation property enforces that a user cannot leave a field empty?**
Answer: Required (Set to Yes)
**४७. What is the shortcut key to close the active database?**
Answer: Ctrl + W
**४८. Which query prompts the user for criteria before running?**
Answer: Parameter Query
**४९. In MS Access, calculations can be performed in:**
Answer: Queries and Reports
**५०. Which component allows automated tasks without programming in Access?**
Answer: Macros
### निष्कर्ष
डेटाबेस खण्डमा राम्रो अंक ल्याउन यी ५० प्रश्नहरूको भूमिका महत्त्वपूर्ण हुन्छ।