MS ACCESS MCQ PART 1

“Explore a collection of multiple-choice questions (MCQs) on in computer science, covering key concepts, queries, tables, and database management.”

1. What is Microsoft Access primarily used for?

A) Creating documents
B) Managing databases
C) Editing images
D) Surfing the web

2. In MS Access, what is a table?

A) A collection of forms
B) A collection of records in rows and fields in columns
C) A collection of queries
D) A collection of macros

3. Which object in MS Access is used to retrieve specific data from a database?

A) Table
B) Query
C) Form
D) Macro

4. What is the extension for an Access database file in newer versions (2013 and later)?

A) .mdb
B) .accdb
C) .dbf
D) .xlsx

5. Which object allows you to input, modify, or view records in MS Access?

A) Form
B) Table
C) Module
D) Macro

6. What is the maximum number of characters allowed in a field name in MS Access?

A) 64
B) 128
C) 255
D) 50

7. What does the “primary key” in a table do?

A) Links multiple databases
B) Allows duplicate records
C) Uniquely identifies each record
D) Sorts records alphabetically

8. Which data type in MS Access stores lengthy text or combinations of text and numbers?

A) Memo
B) Text
C) Number
D) Currency

9. What is the purpose of a relationship in MS Access?

A) To secure the database
B) To connect tables based on common fields
C) To format tables
D) To define field sizes

10. Which tool in MS Access helps in creating a detailed report from the data?

A) Query Wizard
B) Form Wizard
C) Report Wizard
D) Table Design