Class 8 Computer Chapter-4 ''Working With Queries''

 Chapter-4 ''Working with Queries''

A) Fill in the Blanks:-

1) Queries are made on Tables.

2) In a query, the Criteria property is used to set the condition on the basis of which the records are filtered.

3) We can set multiple criteria in a query using Or property.

4) Sort property is used to filter the data either in ascending order or descending order.

5) The bottom pane of the select query window displays the Design Grid.

6) A Report is an effective way to organize and summarize data in a printed form.

B) State True or False. Also correct the false statement.

1)Queries help us to retrieve information from one or more tables that meet a specific condition.:-True.

2)Query window is divided into three parts.:-False. Query window is divided into two parts.

3)To specify multiple criteria, Or property is used.:-True.

4)We cannot run a query without saving it.:-False. We can run a query window without saving it also.

5)The Sort property is used to filter the data either in ascending order or descending order.:-True.

6)Queries are used to explain the specific data.:-True.

7)Once a relationship is set, it cannot be deleted.:-False. Once a relationship is set, it can be deleted.

8)MS Access provides two ways to create Select queries.:-True.

C)Application Based Questions.:-

1)Swati created a database of her classmates and entered 30 records in it. The teacher asked her to show the data of those students who have scored less than 50% marks. Suggest the method to apply this criteria.

Ans:- Swati needs to create query with criteria as <50%.

2)Johnson and Johnson company has a huge database of employees. The company wants to maintain the privacy of each employee and has given the instructions to computer operators to update each record, one at a time. Which database object should they use to perform this task?

Ans:- They should use FORM object to perform this task.

D)Multiple Choice Questions:-

1)b-Update

2)b-two

3)c-Wizard

4)a-Selected Table

5)b-Three

6)a-Primary Key

E)Answer the following Questions:-

Q1) What is a Query?

Ans: A query is a database object that helps us to retrieve and view information from one or more database tables that meet a specific condition or criteria we define.

Q2) Explain the parts of a Query window.

Ans: The query window is divided into two parts/panes:Top pane & Bottom pane.                                                                                                         The Top Pane displays the table(s) selected for the query. In case of multiple tables, the field lists are joined by a line.                                   The Bottom Pane displays the Design Grid. The Design Grid contains Fields, Table, Show, Sort, Criteria and Or. 

Q3) What do you understand by criteria?

Ans: Criteria property contains the condition on the basis of which the records are filtered in the Query output. We specify criteria in the criteria row on the design grid.

Q4) Into how many types a query can be categorized?

Ans: Queries can be categorized into four types- Select Query, Update Query, Cross Tab Query, Append Query.

Q5) Explain how to add fields to a query.

Ans: We can add fields to a query by dragging them from the field list to the design grid or by double-clicking on the field. The design grid is similar to a spreadsheet with columns representing each field in the query.

Q6) What is a Form? Briefly explain its use.

Ans: A form is an MS Access object that allows the user to add and update data in one record at a time in a table.                                                               Usage of form: Data can be inserted, updated and deleted from a table using the FORM object.