IT Planet Class 8 Computer Chapter 4 Solution

IT Planet Class 8 Computer Chapter 4 Solution – Query & Reports In MS-Access

IT Planet Class 8 Solution: IT Planet Class 8 Computer Chapter 4 Query & Reports In MS-Access all Question Answer Solution by Expert Computer Teacher. Here Students can here all Questions Accurate Answers of Chapter Query & Reports In MS-Access Solution.

 

Q1) Tick ( √ ) the correct answer :-

a) A question represented in a way that Access can understand

Ans: ii) Query

b) The shortcut key to save query is

Ans: i) Ctrl + S

c) Query used to display the records that have same values for one or more specified fields.

Ans: iii) Duplicate query

d) While sorting on more than one field, the more important field is called

Ans: iii) Major key

e) A way of displaying data from a query or a table is an appealing way is known as

Ans: i) Report

f) The two special wild cards for Query provided for Access are

Ans: ii) * and ?

 

Q2) Fill in the blanks :-

a) A query can be created using Design view and using the wizard.

b) To create a selected query Design view can be used.

c) Run button is present on Design tab.

d) Duplicate query is used to display the records that have the same values for one or more of the specified fields.

e) The conditions that identify the records you want to find is called Compound criteria

f) The fields on which the records are sorted is called the sort key in Report.

g) The lines that are printed for each record are called detail lines

h) Blank Report is the quick way of building a report.

 

Q3) Answer the following questions :-

a) Solution:

Query is a simple question that you ask to find some specific information from a
database or on the basis of the search conditions query allows the user access information from one or more tables. Queries can be made on tables and the results are being displayed in the form of table i.e is in the format of rows and columns with the set of records that matches the given condition. There are two major parts of the query window which are :

i) Design area :- It is also known as top portion which shows tables, fields, or
subqueries that you may want to use in query.

ii) Grid portion :- It is also known as lower portion. It contains the columns in which
the user can set up the fields.
There are manly three types of Queries which are :-

ii) a) Simple Query :- In database, if you want to ask any questions in relation to data.

b) Unmatched Query :- As the name suggests that it is used to search for the records in the first table which does not have relative/corresponding values in the second table.

c) Duplicate Query :- This query helps the us in finding or showing the records that have the same values in one or more specified fields.

 

b) Solution:

It is the property which contains the condition on which the records are been filtered in the Query output.

 

c) Solution:

In Access, wildcards are used to show the characters or collection of characters in the form of symbols. There basically two types of wildcards are :-

i) Asterisk ( * ) :- This is the first wildcard from the two. This wild card shows the
collection/group of characters. If incase we make use of R*, after which it will show
the letter R and after that follows any collection of characters.

ii) Question mark ( ? ) :- This wildcard is used to show the individual character. This
R?vi represents the letter A, followed by any single character that follows the letter
such as in ‘Ravi’.

d) Solution:

The difference between compound criteria and comparison operator are as followed :-

i) Compound criteria :- One criteria or more than that criteria is needed in satisfying/providing the data that we are finding. Such type of criteria is to be termed as compound criterion. AND criterion and OR criterion are the two examples of compound criterion. In the AND criterion, if an individual criterion is true then the compound criterion is also true whereas OR criterion is true provided either of the individual criterion is true.

ii) Comparison operator :- In Access, it is assumed that the criterion which you have
entered must be equal (must of exact matches). Rather than the exact match, if
you want other thing then you need/ have to type the correct comparison
operator. Greater than ( > ) , Less than ( < ) , >= (greater than or equal to) , <= ( less
than or equal to ) , and < > ( not equal to ) are some examples of the comparison
operators.

e) Solution:

Sorting means arranging the records in the fields into a proper order of alphabetical order, in numerically or as per the data. If you want to give answer against the query asked, then there is a requirement od arranging the records in a proper order. For ex :- There are several students who are participating in the dance and they are been entered into the form named as dance. So with the help of sorting you may arrange the form into proper order. Sort key is the field or fields on which the record is sorted.

 

f) Solution:

i) Primary sort key :- If incase you are sorting more than one field, the most important field is called the major key (which is known as primary sort key)

ii) Secondary Sort key :- If incase you are sorting more than one field, the least important field is called the minor key (which is known as secondary sort key)

 

g) Solution:

It is the method of showing the data from the query or from the table in an
understanding way. Generally reports are made for the purpose of printing. As the reports are to be printed, so reports generally have designed formatting or layouts. You can make use of basic/ by default settings for making basic reports whereas you can adjust the settings as per the requirement in terms of making custom reports. The custom title appears at the top part of the report which is known as page header. At the page header (top part of the reports page) whatever the contents are there, it gets displayed on each report pages. The lines should be specified those are to be printed for each records should contain those fields that you suggest or specify or the orders. The information to create the reports is taken from the tables or queries. The information that is provided by the tables or queries are known as report’s record sources. You can create your own reports from scratch by the two methods such as Layout view or Design view. As compared to the Design view, Layout view is very easy in creating reports as we get the preview of the report. The page in the report can be of both the orientation that is Portrait and Landscape, and its by default page size for letter page is 8.5 inches X 11 inches. Following are the steps to create a report are :-

i) Click on create tab

ii) From the Reports group select and click on the Blank Report tool.

After which in the layout view a Blank report appears showing the Field list at the right
side of the window.

iii) In the Field list pane, click on the plus sign next to the table name whose fields you
want to add in the report.

iv) Now you have to drag each field one at a time on the report or by pressing the ctrl
key along with selecting several fields and drag them all to the report.

v) In the report if you want to format it by making an addition of logo, title page
numbers or date and time, then you can do it by selecting the tools from the
Controls group on the Format tab.

Updated: May 26, 2022 — 11:50 am

Leave a Reply

Your email address will not be published. Required fields are marked *