CHAPTER 4 RAISING QUERIES CLASS 8 COMPUTER

CLASS 8

CHAPTER 4 RAISING QUERIES

A. Fill in the blanks with the help of the given words.

1. Connecting tables in a database is the concept of relational database.

2. A foreign key is the primary key of another table which creates a link between two tables based on a common column.

3. If you modify the primary key value,Cascade update related fields  allows you to update all the related foreign key values.

4. A query  allows you to pull information from one or more tables based on a set of defined search conditions.

5. The query design view allows you to customise the query.

    B. Tick the correct answer.

1. Which of the following options allows you to delete the related records from the foreign key table, if you delete records from the primary key table?

ANS B. Cascade delete related records

2. Which option in Edit Relationships dialog box prevents you from entering a value in the foreign key field?

ANS B. Enforce referential integrity

3. Press.......... to find a particular entry in a table.

ANS D. Ctrl+F

4. What is the function of 'Filter' in the Sort and Filter group?

ANS C. To hide the data

5. Which of these provides a step-by-step approach to create a query in a database?

ANS B. Query Wizard

6. Which of these helps in retrieving blank columns in a database?

Ans   b. Null value

7. A tool of a relational database that is more powerful than searching or filtering records.

Ans  b. Query

8. In which tab will you find Query Wizard option?

Ans  c. Create

C. STATE TRUE or FALSE

1. A relational database should contain only one table. FALSE

2. You need to click on 'Relationships' to set a foreign key. TRUE

3. Enforce referential integrity prevents you from entering a value in the foreign key field, if a corresponding value does not exist in the primary key field. TRUE

4. DD/MM/YYYY is the data format when the language of your computer is set to English (U.K.)

TRUE

5. Filtering deletes the records in a database. 

FLASE

 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

1. Open the table, query, or form.

2. Click on the value you want to filter by.

3. Go to the Home tab.

4. Click Selection in the Sort & Filter group.

5. Choose a filter option (e.g., “Equals”, “Does Not Equal”, etc.).

Q3. Explain the process of raising a query using a query wizard.

Ans3  The steps to use query wizard method are as follows: 

(i) Click the Create tab. 

(ii) In Queries group, click the Query Wizard. A dialog box opens. 

(iii) Click the Simple Query Wizard. 

(iv) Press OK in the above screen. The Simple Query Wizard dialog box opens. Now click on ‘>’ button and select the fields to retrieve. However, pressing ‘>>’ button selects all the fields.

 (v) Click the Next button. Enter the title of query and click the Finish button.

 (vi) The query title show up as the name of the tab where the query shows up.

Q4. How does the criteria option help in defining the results of a query?

ANS4. Criteria options in a query allow users to filter and refine

 the results by specifying conditions that data must meet to be included in the output. This helps narrow down the results to only the most relevant information, making it easier to analyze and understand specific data sets. 

Q5. How will you run a query?

ANS- To run a query in MS Access on the design tab, in the results group, click run to execute the query.