Introduction to MS Access Class 7 MCQ: CBSE Board Class 7 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Introduction to MS Access Class 7.
Introduction to MS Access Class 7 MCQ with Answers and Explanations:
(1) It is a collection of data that is organized in such manner that it can be easily accessed.
(a) Information b) Database c) Data d) None of these
Explanation :-Database is a collection of data that is organized in such a manner that is easier for accessing data. You might have heard a system called ‘ Sampoorna ‘ that contains all the information about the students in our public schools. The data regarding lakhs of students have be compiled systematically. Such collection of data in a systematic manner is called databases. In databases, the data is recorded in one or many tables. Database helps to store data securely , add new data, removes unwanted data, uses data as per need , makes suitable changes etc. For ex:- Telephone and address books are examples of paper databases.
(2) It contains multiples tables in which they are been linked.
(a) Absolute b) Relative c) Rational d) Relational
Explanation :-The data items that are related to each other when the data is been stored. It handles multiple tables which stores/ arranges the text in rows and columns. For ex:- you are going to make two tables one table for customers and the other for orders. The table named as customers will only store the basic information of all the customers and the other order table will only store the information/details regarding the orders placed. Every customers in the customer table are been allotted a unique ID and the each orders in the order table has the specific customer ID.
(3) In MS- Access it is a collection of tables.
(a) Information b) Database c) Data d) None of these
Explanation :- In MS- Access Database is a collection of tables that is been arranged in the form of Rows and Columns. Rows in a table of MS-Access are known as Records whereas columns are known as Fields.
(4) In the table of MS-Access, rows are called as
(a) Records b) Horizontal line c) Fields d) Database
Explanation :-of the table. Each record (row) within a table must be unique. No two records in a table can be exactly identical. Records includes the information about a given person, product or an event.
(5) In the table of MS-Access, rows are called as
(a) Records b) Horizontal line c) Fields d) Database
Explanation :- Fields (columns) contains the actual data that describe and distinguish the items maintained in a table. For ex :- Roll No, First __ Name, Middle _ Name, Last _ Name, Address, City, Mob _ Num etc.
(6) The table form of spreadsheet grid
(a) MS-Excel b) Datasheet c) Worksheet d) Answer sheet
Explanation :- In the Datasheet, every table gets displays in the form of spreadsheet gridlines. You can create forms (which are just like dialog boxes) in the datasheet, which helps the user in typing field entries which makes much easier in making data entries.
(7) It is like a saved filter.
(a) Fields b) Reports c) Records d) Queries
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.
(8) It displays the data in a very attractive manner in tables and queries.
(a) Fields b) Reports c) Records d) Queries
Explanation :- Reports displays the data in a very attractive way in the form tables and queries, gets completed with filters, titles, headers and footers, and graphics.
(9) By pressing this key it is much easier for one to hide or show the Navigation Pane.
a) F11 b) F10 c) F5 d) F2
Explanation :-By pressing F11 key one can hide or show the Navigation pane. The database objects like tables, queries, reports and forms can be viewed or managed with the help of Navigation Pane.
(10) The abbreviation of DBMS is
(a) Database Management System b) Data Managing System
c) Data Management System d) Direct Managing System
Explanation :-DBMS stands for Database Management System. It is a software, that makes it convenient to do such activities with database is called a Database Management System (DBMS).It helps us to create new databases and use them securely. User, does not directly handles the database, but with the help of software it uses. DBMS also acts as a link between user and the database. MySQL, Microsoft SQL Server, Oracle etc. are well known database management system. LibreOffice Base, Microsoft Access, etc. are some of the DBMS applications that comes as part of office packages.
(11) A column in a table whose values uniquely identify the rows in the tables.
(a) Master key b) Secondary key c) Primary key d) None of these
Explanation :- One field or group of fields designed in database, together form as Primary Key. The property of a primary key is that not more than one record is allowed with the same value for the field. Without filling in the value of a primary key field, its impossible to add a record in a table.
(12) It includes the prebuilt tables
(a) Themes b) Templates c) Graphics d) File name
Explanation :- In Access, Templates are the built in tables and forms which helps the user in filling the data into the database very easily.
(13) The files in MS-Access are saved with the file extension by default.
(a) .docx b) .xlsx c) .ppt d) .accdb
Explanation :- When the file is saved in MS-Access with the name that the user assigns to for the first time, the file is automatically stored with the file extension of .accdb
(14) It is the easiest way in creating objects.
(a) Wizard b) Template c) Themes d) None of these
Explanation :-If you want to create objects in the database in an easier manner, then the user needs to make use of the Wizard.
(15) This shortcut key combination is used for opening the previously created database.
(a) Ctrl + N
b) Ctrl + O
c) Ctrl + I
d) None of these.
Explanation :- If incase the user wants to open the database which he/she had created previously, then the user needs to press Ctrl + O short cut key combination from the keyboard. You open the database for entering the data into it or analyzing the data.