7th

---

I. Fill in the blanks. (0.5 × 6 = 3)

(Design, Criteria, Primary Key, Field Size, Datasheet, Design)

1. ---

2. ---

3. ---

4. ---

5. ---

6. ---

---

II. Choose the correct option. (0.5 × 6 = 3)

1. a. ☐ b. ☐ c. ☐ d. ☐

2. a. ☐ b. ☐ c. ☐ d. ☐

3. a. ☐ b. ☐ c. ☐ d. ☐

4. a. ☐ b. ☐ c. ☐ d. ☐

5. a. ☐ b. ☐ c. ☐ d. ☐

6. a. ☐ b. ☐ c. ☐ d. ☐

---

III. Write True or False. (0.5 × 4 = 2)

1. ---

2. ---

3. ---

4. ---

---

IV. State the differences. (2 × 2 = 4)

1. ---

2. ---

---

V. Answer the following questions. (2 × 3 = 6)

1. ---

2. ---

3. ---

---

VI. Write the steps. (2 × 1 = 2)

1. ---

---

I. Fill in the blanks. (0.5 × 6 = 3)

1. The Primary Key field is unique and cannot have duplicate values.

2. The conditions are specified in the Criteria row of the Query Design Grid.

3. The Field Size property determines the maximum number of characters allowed in a text-based field.

4. The Query results are displayed in the Datasheet view.

5. To set the field data types and properties, use the Design view.

6. Data is not visible in Design view of a form.

---

II. Choose the correct option. (0.5 × 6 = 3)

1. Which object in Access allows you to organize and display data based on specific criteria?
   Answer: b. Queries

2. Which view of a report allows you to adjust margins, size and orientation?
   Answer: c. Print Preview

3. In the query design grid, which option is used to arrange records in ascending or descending order?
   Answer: b. Sort

4. Unit_Price × Quantity → Total_Cost auto-calculated.
   Answer: b. Unit_Price: Number, Total_Cost: Calculated

5. Which view is NOT available for a Form object?
   Answer: b. Datasheet View

6. Which combination of data types allows storing multimedia files?
   Answer: a. OLE Object + Attachment

---

III. Write True or False. (0.5 × 4 = 2)

1. Forms let us view, update and delete records from the table. — True

2. We can change the structure of the report in the Report view. — False

3. Reports can be based on Table only. — False

4. Criteria under different fields in Criteria row are combined using OR. — False
   (Same row = AND; Different row = OR)

---

IV. State the differences. (2 × 2 = 4)

1. Number and AutoNumber data type

   • Number: Stores numeric values entered by the user.

   • AutoNumber: Automatically generates a unique number for each new record.

2. Form and Report

   • Form: Used for entering, viewing, and editing data.

   • Report: Used for presenting and printing data in a structured format.

---

V. Answer the following questions. (2 × 3 = 6)

1. What are the two ways to create tables in Access?

   • Using Datasheet View

   • Using Design View

2. What is a primary key?

   • A Primary Key is a field that uniquely identifies each record in a table. It cannot have blank or duplicate values.

3. How can you specify multiple conditions while designing a query?

   • Enter conditions in the same row for AND conditions.

   • Enter conditions in different Criteria/Or rows for OR conditions.

---

VI. Write the steps. (2 × 1 = 2)

1. How do we set a Primary Key in Access?

   • Open the table in Design View.

   • Select the field to be made primary key.

   • Click the Primary Key button on the Ribbon (Design tab).

---