Skip to main content

Bit by Bit | Chapter 3 Working with Queries, Forms and Reports | Class 8 CBSE | Computer Application

Working with Queries, Forms and Reports Exercise Solution


A. Tick the correct option –

1. (d) Datasheet View

2. (c) Three

3. (c) Four

4. (b) Datasheet View

5. (d) Filter

6. (b) Create

B. Fill in the blanks –

1. Query

2. Form

3. Objects

4. Design

5. Report

6. Result

C. State True or False –

1. T

2. F

3. T

4. T

5. F

6. T

D. Answer the following questions –

1. What is Query?

A query is a method of getting answers to questions on data. It is used to retrieve selective data satisfying specific criteria.

2. Differentiate between Form and Report.

Forms allow you to add and update data in a table, one record at a time, while reports are an effective way to present data in printed format. You can customize the appearance of tabular data on a report.

3. How can you specify multiple conditions while designing a query?

Specifying the condition in the Criteria row for more than one field will result in a query that will select only those records that meet all the conditions.

4. What is the use of Print Preview and Design View of a report?

Print Preview view displays the report as it will appear after printing. In design View it displays only the structure of your report. In this view you cannot see the underlying data, but you can perform some tasks such as editing header and footer of the columns and page.

5. What is the use of the Layout View and Design View of a form?

Layout View – You can view the data and make changes in the form, such as changing the size of the various controls.

Design View – Design View displays only the structure of your form. In this view you cannot see the underlying data but you can perform some tasks such as changing the label names, etc.

6. Write the steps to print a report.

To print a report in Ms access follow the below steps:

Step 1 – Click on the down arrow under the view option in the view group on Home Tab or Design Tab.

Step 2 – Click on Print Preview option.

Step 3 – Select the appropriate values for page Size, Margins and Orientation from the ribbon.

Step 4 – Click on the print option to print the report.

 


Comments

Popular posts from this blog

Q & A Chapter 1 | Internet Basics | Class 10 CBSE | Computer Application

 Q & A of Chapter 1 Internet Basics A. Tick the correct options – 1. (b) TCP/IP 2. (a) Internet Service Provider 3. (a) URL 4. (b) HTTP 5. (a) Bridge 6. (a) home page 7. (d) All of these 8. (b) Domain Naming System 9. (b) Rules 10. (d) ARPANET B. Very Short Answer Type Questions – 1. In the URL http://www.myfirm.co.in/about.html , what do the following components depict? (a) http                                                 (b) in (a) Http represents a type of server and the protocol on the Internet (b) ‘in’ represents the domain extension of the website. 2. In the URL http://www.favmusic.com/contactus.html what does www.favmusic stand for? www.favmusic represents the domain name i.e. favmusic in www. 3. W...

Bit by Bit | Chapter 3 - Working with Queries, Forms and Reports | MS Access | Class 8 CBSE | Computer Application

Solved Exercise Question and Answers of  Chapter 3 - Working with Queries, Forms and Reports A. Tick the correct option – 1. (d) Datasheet View 2. (c) Three 3. (c) Four 4. (b) Datasheet View 5. (d) Filter 6. (b) Create B. Fill in the blanks – 1. Query 2. Form 3. Objects 4. Design 5. Report 6. Result C. State True or False – 1. T 2. F 3. T 4. T 5. F 6. T D. Answer the following questions – 1. What is Query? A query is a method of getting answers to questions on data. It is used to retrieve selective data satisfying specific criteria. 2. Differentiate between Form and Report. Forms allow you to add and update data in a table, one record at a time, while reports are an effective way to present data in printed format. You can customize the appearance of tabular data on a report. 3. How can you specify multiple conditions while designing a query? Specifying the condition in the Criteria row for more than one field will result in...

CBSE Class 8 Chapter 1 Networking

Exercise – A. Tick the correct option – 1. A network in which two or more computers are connected within a small area such as a room is called LAN 2. A network which is organised around a person is known as PAN 3. A computer which provides services to the clients and controls access to hardware, software and other resources is known as Server 4. In which year were twisted pair cables invented? 1881 5. Coaxial cables were invented in 1880 6. The network topology which combines the characteristics of bus and star topologies is Tree B. Fill in the blanks – 1. In bus topology, all computers are connected by cables to central device called hub or switch. F 2. In Mesh topology, every computer is connected to every other computer on the network. T 3. There are two general levels of network security. T 4. The optical fibre cable consists of a central glass core surrounded by several layers of protective materials. T 5. Bluetooth technology was...