Query & Reports in MS Access Class 8 MCQ: CBSE Board Class 8 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Query & Reports in MS Access Class 8.
Query & Reports in MS Access Class 8 MCQ with Answers and Explanations:
1.) The question that is represented in such a way that MS-Access can understand
a) Query b) Form c) Reports d) None of these
Explanation :-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.
2.) There are ………………. major parts of Query window in MS-Access
a) Two b) Three c) Four d) Seven
Explanation :-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.
3.) The query type that helps to find the records that have same values in one or more fields.
a.) Simple query b) Unmatched query c) Duplicate query d) None of these
Explanation :- In MS-Access Duplicate query helps the user in finding or showing the records that have the same values in one or more specified fields.
4.) The type of query that is used for searching the records in the one/first table but does not have any same vales in the second table.
a) Simple query b) Unmatched query c) Duplicate query d) None of these
Explanation :-As the name (Unmatched query) 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.
5.) There are ……………………. types of queries.
a) Two b) Three c) Five c) Six
Explanation :-There are mainly three types of Queries which are :-
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.
6.) Run button is present on
a) Home tab b) View tab c) Design tab d) None of these
Explanation :- Once the query is been created by you, now it’s the time for you get the desired results and for that purpose theirs is a need for you to run a query. In the Design tab under Results group category, you may find the Run button. The steps which are necessary for performing and obtaining the results is been done by Access and the result is been displayed. The answer i.e is the sets of records is been displayed in the datasheet view.
7.) This are the conditions that identifies the records that you want to find.
a) Query b) Criteria c) Records d) Statement
Explanation :-Criteria is the property which contains the condition on which the records are been filtered in the Query output.
8) AND criterion and OR criterion are the two examples of
a) Comparison Criteria b) Compound criteria
c) Complex criteria d) All of these
Explanation :-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.
9) In MS-Access, the operator that is assumed that the criterion which you have entered must be equal (must of exact matches).
a) Arithmetic operators b) Logical operators
c) Boolean operators d) Comparison operators
Explanation :-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.
10) In Access, these are used to show the characters or collection of characters in the form of symbols.
a) Wild cards b) Wild characters c) Wild text d) None of these
Explanation :- In Access, wildcards are used to show the characters or collection of characters in the form of symbols.
11) The wild card that shows the collection/group of characters.
a) Asterisk (*) b) question mark (?) c) Comma (,) d) Full stop or period (.)
Explanation :-Asterisk (*) 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.
12) The wildcard that is used to show the individual character.
a) Asterisk (*) b) question mark (?) c) Comma (,) d) Full stop or period (.)
Explanation :- Question mark (?) 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’.
13) The arranging of records in the fields into a proper order of alphabetical order, in numerically or as per the data
a) Adjusting b) Organizing c) Arranging d) Sorting
Explanation :- 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.
14) There are ………………… types of sort keys that are used for sorting the records on the field.
a) Three b) two c) five d) four
Explanation :-Sort key is the field or fields on which the record is sorted.Basically there are two types of sort key which are
a) 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)
b) 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)
15) The method of showing the data from the query or from the table in an understanding way.
a) Query b) Reports c) Sort key d) Wildcards
Explanation :- 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.