Kips Class 8 Cyber Beans Chapter 4 Working With Queries


Chapter 4 Working With Queries

Brain Developers
A. Fill in the blanks:
1. A query is a database object that helps us to retrieve and view information from 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)
Correct Answer:
We can run a query without saving it.
5. The Sort property is used to filter the data either in an ascending order 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)
Correct Answer:
Once a relationship is set, it can be deleted.
8. The Form view is used to change the structure of your form. (False)
Correct Answer:
The form view is used to enter, edit and view data.

C. Application Based Questions:
1. Swati created a database of her classmates and has entered 30 records in it. The teacher has asked her to show the data of those who have scored less than 50% marks. Suggest her the method to apply this criterion.
Answer:
She has to specify ‘<50’ in the Criteria row of the Design grid so as to display the names of the students who have scored less than 50% marks.

2. 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?
Answer:
Johnson & Johnson company should use forms to perform this task as forms allow to add and update data in one record at a time in a table.

D. Multiple Choice Questions:
1. Which Query allows addition, deletion, updation, and appending operations on data?
a) Select query
b) Action query
c) Cross query
Answer:
b) Action query

2. Which query prompts you for input before it runs?
a) Cross tab query
b) Parameter query
c) Select query
Answer:
b) Parameter query

3.Which option is used to change the appearance and size of various controls of a form?
a) Design View
b) Form View
c) Layout View
Answer:
a) Design View

4. Which one of the following is not a type of Query?
a) Select
b) Cross-tab
c) Design
Answer:
c) Design

5. How many views does Access provide to display a form?
a) Two
b) Three
c) Four
Answer:
b) Three

6. Which key defines a relationship between two tables?
a) Primary key
b) Candidate key
c) Secondary key
Answer:
a) Primary key

E. Answer the following:
1. What is Query?
Answer:
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.

2. Explain the parts of a Query window.
Answer:
The Query window has two panes: Top and Bottom. The top pane displays the table selected for the query while the bottom pane displays the Design Grid.

3. What do you understand by Criteria?
Answer:
Criteria are the conditions on the basis of which the records are filtered in the Query output.

4. How many types of Queries are there in MS Access?
Answer:
Microsoft Access provides various types of queries: Select, Parameter, Cross-tab, Action and SQL (Structured Query Language) query.

5. Differentiate between Select and Parameter query.
Answer:
Select query retrieves data from one or more table and displays the record set in a datasheet, whereas, Parameter query prompts you for input and uses that input as criteria that control the result.

6. What is a Form? Briefly explain its use.
Answer:
A form is an Access object that allows the user to add and update data in one record at a time in a table. Data can be easily inserted, updated, and deleted from a table using a Form. If you change a record in a form, it will be reflected in a table also.

7. What is a Report? How will you print a Report?
Answer:
Report is an effective way to organise and summarize data for viewing or printing. It can be created exactly in the same way as we create a form. To print a Report, select the File tab and then click on Print > Print Preview option button on the Quick Access Toolbar.

No comments:

Post a Comment

Also read!

Click on any of the below text for additional links:

Class 6

Class 6 Computer Kips Solutions
Class 6 Gul Mohar English Solutions
→ Class 6 Map Pointing Solutions
Class 6 NCERT Civics Solutions
Class 6 NCERT Geography Solutions
Class 6 NCERT History Solutions
Class 6 NCERT Maths Solutions
Class 6 NCERT Science Solutions

Class 7

Class 7 Computer Kips Solutions
Class 7 Gul Mohar English Solutions
English Grammar Class 7
English Writing Skills Class 7
Class 7 Map Pointing Solutions
Class 7 NCERT Civics Solutions
Class 7 NCERT Civics Notes
Class 7 NCERT Civics Extra Questions
Class 7 NCERT Geography Solutions
Class 7 NCERT Geography Notes
Class 7 NCERT Geography Extra Questions
Class 7 NCERT History Solutions
Class 7 NCERT History Notes
Class 7 NCERT History Extra Questions
Class 7 NCERT Maths Solutions
Class 7 NCERT Science Solutions
Class 7 NCERT Science Notes
Class 7 NCERT Science Extra Questions

Class 8

Class 8 Kips Artificial Intelligence Solutions
Class 8 Gul Mohar English Solutions
English Grammar Class 8
English Writing Skills Class 8
Class 8 Map Pointing Solutions
Class 8 NCERT Civics Solutions
Class 8 NCERT Civics Notes
Class 8 NCERT Civics Extra Questions
Class 8 NCERT Geography Solutions
Class 8 NCERT Geography Notes
Class 8 NCERT Geography Extra Questions
Class 8 NCERT History Solutions
Class 8 NCERT History Notes
Class 8 NCERT History Extra Questions
Class 8 NCERT Maths Solutions
Class 8 NCERT Science Solutions
Class 8 NCERT Science Notes
Class 8 NCERT Science Extra Questions
Class 8 NCERT Science Exemplar
Class 8 NCERT Science MCQs

Class 9

Class 9 Kips Artificial Intelligence Solutions
Class 9 Map Pointing Solutions
Class 9 NCERT Civics Solutions
Class 9 NCERT Geography Solutions
Class 9 NCERT History Solutions
Class 9 NCERT Maths Solutions
Class 9 NCERT Science Solutions

Class 10

Class 10 Kips Artificial Intelligence Solutions
Class 10 NCERT English Solutions
→ Class 10 Map Pointing Solutions
Class 10 NCERT Civics Solutions
Class 10 NCERT Civics Notes
Class 10 NCERT Civics Extra Questions
Class 10 NCERT Geography Solutions
Class 10 NCERT Geography Notes
Class 10 NCERT Geography Extra Questions
Class 10 NCERT History Solutions
→ Class 10 NCERT History Notes
Class 10 NCERT History Extra Questions
Class 10 NCERT Maths Solutions
Class 10 NCERT Science Solutions
Class 10 NCERT Science Notes
Class 10 NCERT Science Extra Questions

Computer Languages

Python Basics

Extra Activities

Extra Activities

Extra Knowledge

Extra Information
General Knowledge
Historical Places in India
Latest technology
Physical Sciences
Facts

• Mathematics quick links
Mathematical Terms
Maths Tricks

Home Top