Defining Data Types and Relationships MCQs

1. In MS Access, a data type defines:
(A) The kind of data a field can store
(B) The format of a report
(C) The relationship between two tables
(D) The primary key automatically

2. Which data type is best suited for storing large text, such as a paragraph?
(A) Short Text
(B) Number
(C) Memo/Long Text
(D) Yes/No

3. Which data type automatically generates a unique number for each record?
(A) Date/Time
(B) Short Text
(C) Number
(D) AutoNumber

4. The Yes/No data type in MS Access is used to store:
(A) Multiple sentences
(B) Only numbers with decimals
(C) Boolean values (True/False)
(D) Primary keys

5. What is the main purpose of defining relationships between tables in MS Access?
(A) To duplicate data
(B) To link related data and enforce data integrity
(C) To create more reports automatically
(D) To change field data types

6. In a relational database, a foreign key is used to:
(A) Identify each record uniquely in its own table
(B) Create a relationship by linking to a primary key in another table
(C) Store large numbers
(D) Encrypt the database

7. Which type of relationship connects one record in a table to many records in another table?
(A) One-to-Many
(B) One-to-One
(C) Many-to-Many
(D) Self-Relationship

8. Which relationship type requires a junction table to manage connections?
(A) One-to-One
(B) One-to-Many
(C) Many-to-Many
(D) Foreign Key

9. Enforcing Referential Integrity in MS Access ensures that:
(A) Duplicate data is allowed in foreign keys
(B) Reports are automatically formatted
(C) Queries run faster
(D) Data in related tables remains consistent

10. Which tool in MS Access is used to define and view relationships between tables?
(A) Query Wizard
(B) Relationship Window
(C) Report Wizard
(D) Form Design View