MS Access MCQ'S

Basic Level MCQs

1. Which of the following is a database management system?
   a) MS Word
   b) MS Excel
   c) MS Access
   d) MS PowerPoint

2. Which object in MS Access stores all the data?
   a) Table
   b) Form
   c) Query
   d) Report

3. What is a primary key in MS Access?
   a) A field that allows duplicate values
   b) A field that uniquely identifies each record
   c) A field used for calculations
   d) A field that stores images

4. Which data type is used to store long text in MS Access?
   a) Short Text
   b) Long Text
   c) Number
   d) Currency

5. What is the purpose of a query in MS Access?
   a) To store data
   b) To retrieve and manipulate data
   c) To design forms
   d) To create reports

---

Intermediate Level MCQs

6. Which MS Access object is used to create a user-friendly interface for entering data?
   a) Table
   b) Query
   c) Form
   d) Report

7. Which field property ensures that every record has a unique value?
   a) Default Value
   b) Validation Rule
   c) Indexed
   d) Primary Key

8. What is a foreign key in MS Access?
   a) A key that is used to create queries
   b) A key that uniquely identifies a table
   c) A field that connects two tables
   d) A key that allows duplicate values

9. Which view allows you to define the structure of a table in MS Access?
   a) Datasheet View
   b) Design View
   c) Form View
   d) Report View

10. What is the function of a Report in MS Access?
    a) To create and store data
    b) To format and print data in a structured manner
    c) To input data into a table
    d) To connect different tables

---

Advanced Level MCQs

11. Which query type is used to retrieve specific data from multiple tables?
    a) Select Query
    b) Crosstab Query
    c) Append Query
    d) Update Query

12. Which of the following is an example of a relational database concept in MS Access?
    a) Using multiple tables and linking them
    b) Storing all data in a single table
    c) Using MS Excel for calculations
    d) Writing reports manually

13. Which function is used to find the highest value in a numeric field?
    a) SUM()
    b) MAX()
    c) COUNT()
    d) AVERAGE()

14. What does the "AutoNumber" data type do in MS Access?
    a) Generates unique values automatically
    b) Stores numerical values
    c) Allows text input
    d) Links tables together

15. Which of the following statements about relationships in MS Access is true?
    a) One-to-One relationships are the most common
    b) One-to-Many relationships link one record to multiple records in another table
    c) Relationships do not require a primary key
    d) Tables cannot be linked in MS Access

---

Additional MCQs (Basic Level)

16. What is MS Access primarily used for?
    a) Word Processing
    b) Database Management
    c) Graphic Design
    d) Web Browsing

17. Which of the following is NOT an object in MS Access?
    a) Table
    b) Query
    c) Slide
    d) Report

18. Which tab in MS Access allows you to create new tables, forms, and queries?
    a) Home
    b) Create
    c) Design
    d) Database Tools

19. Which extension is used for an MS Access database file?
    a) .docx
    b) .xlsx
    c) .accdb
    d) .pptx

20. Which key is used to switch between fields in Datasheet View?
    a) Enter
    b) Tab
    c) Shift
    d) Spacebar

---

Intermediate Level MCQs (Continued)

21. Which key combination is used to save a database in MS Access?
    a) Ctrl + P
    b) Ctrl + S
    c) Ctrl + X
    d) Ctrl + D

22. Which of the following is NOT a valid data type in MS Access?
    a) Currency
    b) Picture
    c) Yes/No
    d) Hyperlink

23. What does the "Lookup Wizard" in MS Access help create?
    a) A relationship between tables
    b) A drop-down list of values
    c) A primary key
    d) A new query

24. Which object is used to summarize and present data in a structured format?
    a) Table
    b) Query
    c) Report
    d) Macro

25. Which function is used to count the number of records in a table?
    a) SUM()
    b) AVERAGE()
    c) COUNT()
    d) MAX()