Kips IT/Cyber Beans Class 8 Chapter 4 Solutions WORKING WITH QUERIES

|

Kips Cyber Beans Class 8 Chapter 4 Solutions is part of Kips Cyber Beans Computer Class 8. Here we have given Kips Cyber Beans Class 8 Chapter 4 Solutions WORKING WITH QUERIES.

Textbook Kips Cyber Beans
Class 8
Subject Computer
Chapter 4
Chapter Name WORKING WITH QUERIES
Other Chapters Chapter 1
Chapter 2
Chapter 3
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10

Kips Cyber Beans Class 8 Chapter 4 Solutions WORKING WITH QUERIES

Brain Developer

A. Fill in the Blanks:

1. A Query is a database object that helps us to retrieve and view information one or more database 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 an ascending or descending order.

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

6. A Report is an effective way to organise and summarise data in a printed form.

B. State True or False:

1. The queries help us to retrieve information from one or more tables that meet a specific condition. – TRUE

2. A report is created exactly in the same way as Forms are created. – TRUE

3. To specify multiple criteria, ‘Or’ property is used. – TRUE

4. We cannot run a query without saving it. – FALSE

5. The Sort property is used to filter the data either in an ascending or descending order. – TRUE

6. A Relationship works by matching a field with the same name in two tables. – TRUE

7. Once a relationship is set, it cannot be deleted. – FALSE

8. The Form view is used to change the structure of your form. – TRUE

C. Application Based Questions:

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

Specify the condition ‘<50’.

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

Use forms to perform this task.

D. Multiple Choice Questions:

1. Which query allows addition, deletion, updation, and appending operations on data?

  1. Select Query
  2. Action Query
  3. Cross Query

2. Which query prompts you for input before it runs?

  1. Cross tab query
  2. Parameter query
  3. Select query

3. Which option is used to change the appearance and size of various controls of a form?

  1. Design View
  2. Form View
  3. Layout View

4. Which one of the following is not a type of Query?

  1. Select
  2. Cross-tab
  3. Design

5. How many views does Access provide to display a form?

  1. Two
  2. Three
  3. Four

6. Which key defines a relationship between two tables?

  1. Primary key
  2. Candidate key
  3. Secondary key

E. Answer the following:

What is a Query?

A query is like a simple question that one asks to find specific information from the database. Queries are made on tables and the results are displayed in the form of a table, i.e., in a group of rows and columns with the set of records that match the given condition.

Explain the parts of a Query window.

The Query window has two panes: Top and Bottom. The top pane displays the table(s) selected for the query. The bottom pane displays the Design Grid.

What do you understand by Criteria?

Criteria are the condition on the basis of which the records are filtered in the Query output.

How many types of Queries are there in MS Access?

Microsoft Access provides various types of queries: Select, Parameter, Crosstab, Action, and SQL (Structured Query Language) query.

Differentiate between Select and Parameter query.

Select query retrieves data from one or more tables and displays the record set in a datasheet, whereas, Parameter query prompts you for input and uses that input as criterial that control the result.

What is a Form? Briefly explain its use.

A form is an Access object that allows the user to add and update data in one record at a time in a table. If you change a record in a form, it will be reflected in a table also.

What is a Report? How will you print a Report?

Report is an effective way to organise and summarise data for viewing or printing. It can be created exactly in the same way as we create a form.

Other Chapter Solutions

    1 thought on “Kips IT/Cyber Beans Class 8 Chapter 4 Solutions WORKING WITH QUERIES”

    Leave a comment