More Features 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 More Features in MS Access Class 8.
More Features in MS Access Class 8 MCQ with Answers and Explanations:
1.) There is a need for the user to …………………… a data in the table before performing any task in MS-Access.
a) Enter b) Delete c) Edit d) Select
Explanation :- In MS-Access before performing any task first of all the user needs to select the data within the table. When the data is been selected, it gets highlighted and is displayed on the screen. The user may particularly select the field, select the record, or select a cell.
2.) It helps the user in quickly search for the tables, queries, and forms for the specified database task.
a) Hunt b) Search c) Find d) Look
Explanation :-In MS- Access the use of Find feature allows the user to search tables, queries, forms in a database easily and fastly without wasting much time. If you wants to search for the records in any of the specified field, then you ay have to select that field, which happens only if the fields are been properly labelled/indexed. If you wants to search for the fields in all the records, then you may have to select the datasheet or form.
3.) This option helps the user to search up or down from the point of insertion.
a) Hunt b) Search c) Find d) Look
Explanation :- In MS -Access Search is a drop down box that is only used to search up or down from the insertion point or in searching the entire document.
4) This feature in MS-Access allows the user to search only the current field
a) Look in b) Find c) Hunt d) Search
Explanation :- In MS-Access, Look in is the drop down box that allows the user to only search for the current field that too faster, or if there are all other fields to be searched within the table, then it will be slower at the time of searching.
5) It means organizing of records into the ascending and descending order.
a) Sorting b) Arrangement c) Adjusting d) All of these
Explanation :- Sorting means arranging the records in a particular order, ascending or descending. You need to select the fields (i.e is depending upon the record which you want to arrange) , if you want to sort the records. You can even change the sequence o f the records within the table. If incase you wish to sort more than one columns then first you must the highlight the column by selecting it and then drag the mouse over the field labels.
6) This helps to review and analyze the information in the database.
a) Short listing b) Filtering c) Filterization d) Grading
Explanation :-Filtering is sued to review or analyze the information in your database. This feature is used only to filter only the records which contains data of interest.
7) There are …………………. number of views that helps the user to display the table.
a) Three b) Five c) Two d) One
Explanation :- MS-Access provides the user two views in which the table can be viewed i.e is Datasheet view and Design view. Datasheet view helps the user in entering the data whereas design view helps the user in modifying the structure of the table.
8) The key that cannot be deleted in MS-Access.
a) Master key b) Foreign key c) Primary key d) Duplicate key
Explanation :- In MS-Access, the fields of the Primary key cannot be deleted, but can delete rest all other field or record content of the field from the table.
9) The connection of databases between the similar multiple tables those are related to each other.
a) Combination b) Relational c) Continued d) None of these
Explanation :-The connection of multiple tables those are related to each other. In the relationships window, you can create and manage relationships between the tables. There is a requirement of the common field between the two tables while creating relationships between them. For the joining or connecting the relationships between the both tables, there should be the existence of fields within the both tables that you want to create relationships. Field in the tables could be the main source for joining of tables. In the database relationship window, by dragging the fields from one table to the other one the relationships between the table is created.
10) The key that is used to keep the relation/link between the two tables.
a) Master key b) Foreign key c) Primary key d) Duplicate key
Explanation :-Foreign key is a key, which is used to keep the link/relation between two tables. It is nothing but a field or collection of field in one table that refers to the primary key in the another table.
11) This allows you to add and update data in a table, one record at a time.
a) Foreign key b) Primary key c) Query d) Form
Explanation :-Form allows you to add and update data in a table, one record at a time. With the making use of data form, it helps the user to enter the database list very fastly. There is availability of all table fields in your data form. By filling/completing the fillation of fields in the form, it is easier for one to enter a record.
12) Forms in MS-Access can be created by making use of
a) Pencil b) Computer c) Form Wizard d) None of these
Explanation :- In MS-Access Forms can be created by making use of Form Wizard. In this wizard, there are many questions asked, which helps to create the forms on the basis of your answers. With the help of form wizard, one can make use of the data in the form from the table.
13) MS-Access ………………… number of views to customize the forms.
Four b) three c) two d) five
Explanation :- There are two views in MS- Access which are used for customizing the form. the views are Design view and Layout view. In the Design view, every object appears as a separate editable, element, in the form whereas Layout view helps to adjust the controls in the form directly and their sizes.
14) The tab that helps user to change the style, colour, alignment etc of the text.
a) Edit tab b) Format tab c) Design tab d) Tools tab
Explanation :- The form those are containing the fields or field labels, you can make/add formatting to them. Formatting such as changing the font size, style, colour, alignment etc of the text available in the form. The formatting to form can be done by making a click on the Format tab but one thing should be remembered the form should be viewed into the Layout view.
15) This is a pre-defined designs which are used to change the look of the form.
a) Animation b) Colours c) Fonts d) Themes
Explanation :- To give the different and a very attractive look to the form, we can make use of the Themes which are pre-defined designs.