1. In MS Access, a table is used to:
(A) Print formatted reports
(B) Generate queries automatically
(C) Create forms for data entry
(D) Store data in rows and columns
2. Each column in a table is known as a:
(A) Record
(B) Field
(C) Query
(D) Report
3. Each row in a table represents a:
(A) Record
(B) Form
(C) Report
(D) Relationship
4. Which of the following defines the type of data a field can store?
(A) Query
(B) Primary key
(C) Data type
(D) Relationship
5. Which data type in MS Access is suitable for storing numbers with decimal values?
(A) Text
(B) AutoNumber
(C) Number/Double
(D) Yes/No
6. The purpose of setting a primary key in a table is to:
(A) Allow duplicate entries
(B) Automatically create reports
(C) Encrypt the database
(D) Uniquely identify each record
7. What happens if you try to enter duplicate values in a primary key field?
(A) Access displays an error
(B) Access accepts the entry
(C) Access deletes the duplicate record
(D) Access converts it into a foreign key
8. Which view in MS Access is primarily used to design and define fields of a table?
(A) Datasheet View
(B) Design View
(C) Report View
(D) Form View
9. Which view is used to directly enter and edit records in a table?
(A) Form View
(B) Query View
(C) Datasheet View
(D) Relationship View
10. In MS Access, which feature prevents invalid data from being entered into a field?
(A) Validation Rule
(B) Data Type
(C) AutoNumber
(D) Report Wizard