Tables in Microsoft Access Class 8 MCQ: CBSE Board Class 8 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Tables in Microsoft Access Class 8.
Tables in Microsoft Access Class 8 MCQ with Answers and Explanations:
1.) It is a powerful database software that is used for creating, managing and processing the data in the form of table.
a) MS-Word b) MS-Excel c) MS-PowerPoint d) MS-Access
Explanation :-MS- Access is one of the part of the MS- Office package suite. It is a database software which is used to create, manage and process data in the table. Every single information in the table is known as a value. The location of the values in between the intersection of row and column. In Microsoft Access, the database is saved with a .accdb extension. The databases in the older access uses an .mdb extension but from from Access 2007,the database began to save with .accdb extension. Using an older version of Access, if you are unable to open an older database, you may need to convert .accdb first
2.) 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.
3.) DBMS stands for
a.) Database Management System b) Database Merging System
c) Data Merging System d) All of these
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.
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, columns 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.) It is the base structure of any database.
a) Oxygen b) Foreign key c) Primary key d) Table
Explanation :- In MS-Access table is the base structure of any database. The table’s structure in Ms-Access states the fields and their properties and specifies about the data is to be entered into the table. 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.
7.) 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
8.) It should be unique name for every field in the table.
a.) Username b) Field name c) Surname d) First name
Explanation :- Field name is the unique name for every field in the table such as students table, the filed names will be as Roll Number, Class, Section etc.
9.) The data type that has character limitation say what of 63,999
a) Text b) Numbers c) Memo d) None of these
Explanation :-Memo Datatype is sued for detailed and descriptive data and has a character limitation of 63,999.
10) This data type helps us to link to websites, e-mail addresses, files on the computer etc.
a) Hyperlink b) Attachments c) Connections d) None of these
Explanation :-You can link to websites, e-mail addresses, files on your computer, files on the LAN or virtually any other location.
11) The field can that can be used as Primary key in MS- Access
a) Autofill b) Auto number c) Preloaded numbers d) Automated Numbers
Explanation :-When new record is been created then unique values of such is created by Auto number. This field can be primarily used as the Primary Key in Access.
12) The key in MS-Access differentiates the records in a file.
a) Common Key b) Primary key c) Foreign key d) Master key
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.
13) The property that is used to control every fields.
a) Field handlers b) Field controllers c) Field properties d) None of these
Explanation :-Field properties are the properties that controls every fields. This properties includes the basic things like size, format as well as the rules for the entries in it.
14) The datatype that has limitation of 255 characters but cannot be used for numeric calculations.
a) Text b) Numbers c) Memo d) None of these
Explanation :-A text field can contain value that that are in text, numeric, or combination of both. A text field can contain upto 255 characters. You may use this fields for the numeric entries that does not require or doesn’t relate with any calculation work such as postal pin codes, telephone numbers etc.
15) This field is sued for creating already created fields in the table.
a) Performance b) Calculated c) Totalled d) None of these
Explanation :-Calculated is the new feature in MS- Access 2010. You can directly create the calculated fields in the table. In the older versions, you could create calculated fields only in queries.