CHAPTER 4 RAISING QUERIES CLASS 8 COMPUTER
Q1. Can you create a relationship between two tables? For what purpose do we create relationships between tables? ANS1. Yes, we can create a relationship between two tables. In relational databases, data is often spread across multiple tables instead of being kept in one large table. Relationship is created between tables for the following purposes 1 Data Integrity : Ensures that related data stays consistent (e.g., a student must be assigned to an existing class). 2 Avoiding Redundancy : Prevents duplication of data 3 Easier Maintenance : Updates happen in one place, not multiple. Q2. How can you filter the records in Access 2016? Ans 2. Steps to filter the records in M S Access 2016 Open the table , query , or form . Click on the value you want to filter by. Go to the Home tab. Click Selection in the Sort & Filter group. Choose a filter option (e.g., “Equals”, “Does Not Equal”, etc.). Q3. Explain the process of raising a query us...