DBMS class 7 chapter 7

 

---

1. Which object in Access allows you to organise and display data based on specific criteria?

a) Tables
b) Queries ✅
c) Forms
d) Reports

✅ Correct Answer: b) Queries
💡 Explanation: Queries in MS Access are used to filter, sort, and display specific data based on given conditions or criteria.

---

2. Which combination of data types allows us to store multimedia files like images, documents and presentations in a table?

a) OLE Object and Attachment ✅
b) Lookup Wizard and OLE Object
c) Attachment and Lookup Wizard
d) Calculated and OLE Object

✅ Correct Answer: a) OLE Object and Attachment
💡 Explanation:

• OLE Object stores files like Word documents or Excel sheets.
• Attachment allows storing multiple files such as images, videos, and documents in a single record.

---

---

Question 3:

In a table with fields ‘Unit_Price’ and ‘Total_Cost’, where ‘Total_Cost’ should be automatically calculated as the product of Unit_Price and quantity sold, which data types should be used for these fields?

a) Unit_Price: Calculated; Total_Cost: Number
b) Unit_Price: Number; Total_Cost: Calculated ✅
c) Unit_Price: Calculated; Total_Cost: Calculated
d) Unit_Price: Number; Total_Cost: Number

✅ Correct Answer: b) Unit_Price: Number; Total_Cost: Calculated

💡 Explanation:

• Unit_Price should be of Number type to store numeric values.
• Total_Cost should be of Calculated type so it can automatically compute values like Unit_Price * Quantity.

---

B. Fill in the blanks using the words in the box:

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

1. Data in a relational database is organised into Tables. ✅
2. The Datasheet view allows us to view, enter, and edit data in a table. ✅
3. To set the field data types and properties, use the Design view. ✅
4. The Field Size property determines the maximum number of characters allowed in a text-based field. ✅
5. The Primary Key field is unique and cannot have duplicate values. ✅

---

 1. Define DBMS and Advantages

Definition:
DBMS (Database Management System) is a software used to store, organize, and manage data easily.
Example: Microsoft Access, MySQL, Oracle

Advantages:

1. Stores data safely

2. Easy to update

3. Avoids duplication

4. Fast searching

5. Multiple users can access

---

2. Difference between Record and Field (3 Points)

Record	Field
A complete set of information about one item or person	A single piece of information in a record
Example: Full details of a student	Example: Student’s Name
Table has many records	Record has many fields

---

3. Difference between Number and AutoNumber (3 Points)

Number	AutoNumber
Stores numeric values like marks, age	Gives unique number automatically to each record
Entered manually	Generated automatically
Example: 45, 90, 120	Example: 1, 2, 3, 4

---

4. Difference between Validation Rule and Validation Text (3 Points)

Validation Rule	Validation Text
Condition to control data entered	Message shown when rule is broken
Example: Marks > 0	Example: “Please enter marks greater than 0”
Checks the data	Explains error to user

---

5. What is Primary Key & How to Set in MS Access

Primary Key:
A field that uniquely identifies each record in a table.
Example: Roll Number in Student Table

Steps to Set Primary Key:

1. Open table in Design View

2. Click on the field name (e.g., Roll Number)

3. Click the Primary Key button (key icon)

4. A key symbol appears next to the field

---

6. 2 Ways to Create Table in MS Access

1. Design View:

   • Define fields, data types, and properties manually

   • Example: Field Name – Roll No, Data Type – Number

2. Datasheet View:

   • Enter data directly in spreadsheet-like view

   • Field names are automatically created (Field1, Field2…) and can be renamed

---