NCERT Solutions Class 10 Computers Microsoft Access

Very Short Answer Type Questions 

Question. What is the default extension of a MS-Access database?
Answer: The default extension of a MS-Access database is .accdb.

Question. How NUMBER and DATE/TIME type fields are different in Access? Give any one difference.
Answer: NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.

Question. Give five names of database templates used in MS-Access 2007.
Answer: Assets, Contacts, Events, Faculty and Issues.

Question. What happens when you enter numbers in a Text data type field?
Answer: Numbers are accepted as a text values.

Question. Name the data type that should be used to store Student’s Admission numbers.
Answer: Data type should be Text.

Question. Give the names of five data types used in MS-Access.
Answer: Text, Memo, Date/Time, Yes/No and Currency.

Question. What happens when text is entered in a Number type field?
Answer: When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”

Question. Is it necessary to define a field type for a field in MS-Access?
Answer: Yes, it is necessary to define a type of a field while entering data into a field.

Question. Write one example of data for which Memo data type is used. 
Answer: To store resume of an employee in Employee table is an example of Memo data type.

Question. Which property should be set, if it is required that ‘Delhi’ is automatically entered in the city field when a new record is created? CBSE 2008
Answer: Default Value property should be set.

Question. Which field property sets limits on the data that is entered? 
Answer: Fixed Field Length or Field Size property sets the limits on the data entered.

Question. For which type of field, “Default Value” property is not applicable? 
Answer: Attachment, AutoNumber, OLE Object.

Question. What is the use of AutoNumber type field used in MS-Access?
or
Define the AutoNumber data type in MS- Access. 
Answer: AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

Question. Which field property specifies whether the field can be left empty when entering data into a record? 
Answer: Required property

Question. What are two areas of the Design View of the table? 
Answer: Field description and Field properties.

Question. What happens, if you do not enter a caption for a field?
Answer: In this case, Field Name is used as a label.

Question. If the data type of a field is set to Text, what will be its number range?
Answer: Its range will be 0 to 255.

Question. What are the views in which fields can be deleted in MS-Access? 
Answer: Datasheet View and Design View.

Question. What is Fixed Field Length?
Answer: It refers to a type of field length in which the number of characters you enter will be fixed.

Question. What are the commands contained by Create tab?
Answer: The Create tab has various commands such as Table Design, Table Templates,Pivotchart, Form, Report, Macro and Query Wizard.

Short Answer Type Questions 

Question. How will you create a blank database in MS-Access 2007?
Answer: Creating a Blank Database
To create a new blank database, you need to perform the steps which are as follows:
- Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will appear.

Question. Explain field length with its types.
Answer: It refers to the maximum number of characters that a field can contain. Each character requires one byte for its storage.
Field length is of two types which are as follows:

1. Fixed length field It is a type of field length in which the number of characters you enter in a field is fixed. These are present in Format option in Data Type Formatting
group (in Datasheet tab) such as Currency, Euro, Percent etc.

2. Variable length field In this type of field length, the number of characters is not fixed.
Actually, the number of characters of the data entered in the field decide the field length.
The field length or field size of each data type are as follows:

Question. What are Datasheet View and Design View?
Answer: In MS-Access 2007, two types of views are available to create a table as follows:
1. Datasheet View It provides a visual way to create a table. It is a simple view which arranges the data in rows and columns and allows to edit the data, but not allows to
change the format of the database, other than minor changes (such as insert or delete columns).
2. Design View It allows you to create or change the table. You can set or change every available properties for each field and can open existing tables in Design View, add, remove or change fields.

Question. Write down the steps to insert a new row into the table. 
or
How can you add a record in the table in Datasheet View?
Answer: Insert a Record
Steps to insert a record in a Datasheet View are as follows:
- Step 1 When you create a table, a new blank record automatically appears in the second row of the table
or
If you enter data in the last record, a new blank record will automatically appear at the end of the table.
- Step 2 Type data into the fields.
Step 3 When you have finished adding records in the datasheet, save it and close it.

Question. How can you delete an Access table from a database?
Answer: Steps to delete a table are as follows:
- Step 1 Find a table in the All Access Objects list.
- Step 2 Right click on a table and select Delete.
- Step 3 Now, MS-Access will display the prompt message to confirm that you want to delete the table or not.
- Step 4 Click on Yes button to delete a table with its contents.

Question. When Memo data type is preferred over Text type for a field?
Answer: When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length can not be more than 255 characters so, Memo data type is preferred over Text data type.

Question. Distinguish between Text and Memo data types. 
or
How are field types Text and Memo different from each other? Explain with the help of an example.
Answer: Distinguishing between Text and Memo are as follows:

Question. When is AutoNumber data type preferred over Number data type? 
Answer: When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.

Question. A text field is initially 40 characters long and one record has an entry in this field in MS-Access database. The field value contains 28 characters, including spaces. Now,
you have reduced the length of the field to 20 characters. What will happen to the field value?
Answer: Since, the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

Question. Write one example of data field for which you would set the Required property to Yes? 
Answer: In a table, when we declare a field as a primary key, then the field’s Required property must be set to Yes because in a primary key field, we need to enter data always.

Question. What is the purpose of Default Value field property?
Answer: If there is a situation when you want to enter same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

Question. What do you mean by the Entry Required field information?
Answer: Entry Required field decides whether entering data in the field is necessary or not.
So, if Entry Required is set to Yes, then that field must have some value in it. By default,Entry Required is set to Yes.

Question. What is a primary key? How do we set a primary key? 
or
Define primary key. How do you set it in MS-Access? 
Answer: Primary key is the key which is used to uniquely identify the records into the table.
To set the primary key you have to follow steps given below:
Step 1 Select the field that you want to set as a primary key.
Step 2 Click Primary Key button from the Design tab.
or
Right click on the selected field and select Primary Key.

Question. Give any one difference between freezing a field and hiding a field. 
Answer: When you freeze a field, then no matter how far you scroll down in a datasheet, you will always see the frozen field. But, when you hide a field, then it means that field is not displayed on the screen.

Long Answer Type Questions 

Question. What is database template? Give the description of five templates, used in Microsoft Access 2007.
Answer: Template is a complete tracking application with predefined tables, forms, reports, queries, macros and relationships. Each template creates a complete end-to-end solution that you can use either with no modification or customise to suit your business needs.
MS-Access 2007 includes a collection of database templates, which are as follows:
1. Assets It is used to create an assets database to keep track of assets, including asset details and owners.
2. Contacts It is used to create a contacts database to manage information about people such as customers, partners etc.
3. Issues It is used to create an issues database to manage a set of issues or problems.
You can assign priority and follow the progress of issues from start to finish.
4. Events It is used to create an events database for tracking, upcoming meetings, deadlines and other important events.
5. Marketing projects It is used to create a marketing projects database to track timesensitive deliverable and vendor status for projects.
6. Projects It is used to create a projects tracking database to track multiple projects and assign tasks to different people.

Question. Explain MS-Access Ribbon.
Answer: The Ribbon contains a series of command tabs. In MS-Access 2007, the main command tabs are as follows:
- Home
- Create
- External Data
- Database Tools
- Datasheet

Question. Write one example of each field, for which you would use 
1. Text data type
2. Memo data type
Answer:
1. Text data type It allows to store text or combination of text and numbers as well as numbers that don’t require calculations such as phone number. This data type allows maximum 255 characters to store.
e.g. if Employee is a table and Emp_No, Name and Description are fields, then name will be a Text field. Because, name is a character entry field.
2. Memo data type It allows long blocks of text that uses text formatting, e.g. in the Employee table, the field Description will be of Memo data type, because the length of description of employee may be large.

Question. Distinguish between Number and AutoNumber data type field. Give example of each.
Answer: Distinguishing between Number and AutoNumber data

Question. Which field properties are used in Office Access 2007? Give the purpose of each field property.
Answer: Field Properties
After you create a field and set its data types, you can also set additional field properties.
Setting field properties can give the database extra flexibility and functionality.
Some important properties of field are as follows

Question. Pronita is a programmer in an institution and is asked to handle the records containing personal information of the teachers teaching in the institution.
Use the information to give the answer of the following questions (1) to (3).
1. Suggest five held names, which you think must be present in the table Teacherlnfo and why?
2. Give the data type of the suggested fields.
3. Which held is most likely to be the key field and why?
Answer: Suggested five fields are as follows:
1. TCode —> To store the code of the teachers.
TName —> To store the name of the teachers.
TSubject —> To store the name of subjects for which the teacher is placed in the institution.
Address —> To store the address of the teachers.
Salary —> To store the monthly income of the teachers.
2. TCode —> Text
TName —> Text
TSubject —> Text
Address —> Text
Salary —> Number
3. TCode is most likely to be the key field because it has a unique value for each of the records.

Question. The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla.

Answer the following questions:
1. State the number of fields in’the above table.
2. State the number of records in the above table.
3. Give one reason why SummerCamp would add a record.
4. Give one reason why SummerCamp would edit a record.
5. Give one reason why SummerCamp would delete a record.
6. Give any two data types used in the table.
Answer:
1. Number of fields-6
2. Number of records-7
3. If a new child joins the SummerCamp, then SummerCamp would add a record in the table.
4. If a child is shifted from one group to another, then SummerCamp would edit a record in the table.
5. If any child leaves the SummerCamp, then SummerCamp would delete a record of that child from the table.
6. Text and Date/Time.

Question. Consider the following database:

Answer the following questions:
1. Write the name of the field that contains numeric data.
2. Identify the primary key field in the database.
3. Identify the field type of the DateofSale field.
4. Identify the names of the fields that contain textual data.
5. The given table contains how many fields and records?
6. Which property should you use, if you want to make sure that the QtySold entered is less than 10?
Answer:
1. Qty Sold and Amount fields
2. ProductCode field
3. Date/Time data type
4. ProductCode, ProductName and CustomerName fields
5. 6 fields and 5 records
6. Validation Rule

Question. Look at the given table called ‘Item’ and answer the questions. 

1. Suggest the data types of all the fields.
2. Which two fields can act as the primary key from the above table?
Answer:
1. ItemID —> Text
ItemName —> Text
ItemStock —> Number
ItemDOP —> Date
QuantityPurchased —> Number
2. ItemID and ItemName can act as primary key.

Question. Damini is a programmer in an institute and is asked to handle the records containing information of students. Suggest any 5 fields name and their data type of students database. 
Answer:

Question. Answer the following questions based on the database given below: 

1. Identify the primary key and justify your answer.
2. Suggest suitable data type for Unit_Cost and justify your answer.
3. If the database is sorted in ascending order of UnitCost. What is the product name of last record?
4. How will you ensure that Supplier_No must not be empty?
5. To add the details of new product, what should the user add: record or field? Write the steps for the same.
6. How will you ensure that ‘1’ must appear in Supplier_No, if no value is entered?
7. How many records and fields are there in the above table?
8. It is needed to add photograph of the product in the database. Which is suitable data type for the same?
Answer:
1. The primary key of the given table Product will be Prod _Id because no two products have same Product_Id. So, it will be uniquely identify for each record into the table.
2. The suitable data type for the field Unit_Cost is Number because this field in the table contains value in numbers only.
3. Crayons
4. By setting the Required property to Yes.
5. To add the details of new product the user should add a record. The steps are as follows:
- Step 1 Open the database.
- Step 2 Open the table in which you want to add a record in a Datasheet View.
- Step 3 If you open the table, a new blank record will automatically appear at the end of the table.
- Step 4 Type the data into the fields.
- Step 5 Save the table.
6. By setting the property Default Value which is to be set as 1.
7. Records = 8, Fields = 8
8. The data type OLE Object is suitable for adding the photograph of the product into the table.

Multiple Choice Questions 

Question. Microsoft Access is an example of
(a) Computer
(b) DBMS
(c) CPU
(d) Device
Answer: (b) MS-Access is the DataBase Management System (DBMS) found in the Microsoft Office suite.

Question. Which of the following is not a part of a table structure in MS-Access?
(a) Field Name
(b) Field Type
(c) Primary Key
(d) Number of Records
Answer: (d) From the given options Field Name, Field Type Primary Key are the part of a table.

Question. In a MS-Access database, which component is not present?
(a) Formula Bar
(b) Tables
(c) Queries
(d) Forms
Answer: (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports,Macros and Modules.

Question. Which of the following is not a data type?
(a) Picture/Graphic
(b) Date/Time
(c) Text
(d) Number
Answer: (a) From the given options Date/Time, Text and Number are the data types.

Question. What data type should you choose for a zipcode field in a table? CBSE 2011
(a) Text
(b) Number
(c) Memo
(d) All of these
Answer: (b) Number data type should be chosen for a zipcode field in a table.

Question. For what, Memo data type is used?
(a) To add table
(b) To store objects created in other programs
(c) For long text entries
(d) For short text entries
Answer: (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

Question. The default data type for a field is
(a) Number
(b) AutoNumber
(c) Currency
(d) Text
Answer: (d) The default data type for a field is Text.

Question. Single and double are the types of
(a) Integer data type
(b) Decimal numbers
(c) Text data
(d) None of these
Answer: (a) Integer data type provides single and double data types.

Question. You create a table in MS-Access. You decided to create two fields RollNo and DateofBirth, what will be the data type for DateofBirth column?
(a) Number
(b) Text
(c) Yes/No
(d) Date/Time
Answer: (d) Date/Time will be the data type because it allows to store date and time format.

Question. Which data type helps you to handle input that is in boolean format?
(a) OLE Object
(b) Attachment
(c) Yes/No
(d) None of these
Answer: (c) Yes/No will allow boolean value.

Question. Which property is used to add a label to the field to assist the user?
(a) Default value
(b) Caption
(c) Format
(d) Indexed
Answer: (b) Caption is used to add a label to the field for assisting to the user.

Question. Which field property helps in setting data validation in a table?
(a) Caption
(b) Default Value
(c) Decimal Places
(d) Validation Rule
Answer: (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

Question. What is the purpose of the description column in table Design View? 
(a) To describe the data that should be entered in each field
(b) To define the data type applied to each field within the table
(c) To enter lookup data, the field should be refer to the table
(d) None of the above
Answer: (a) A Design View of table provides three columns as Field Name, Data Type and Description. The description column provides the facility to write description about Field Name.

Question. An integer takes a storage size of
(a) 2 bytes
(b) 1 byte
(c) 4 bytes
(d) 8 bytes
Answer: (a) An integer takes a storage size of 2 bytes.

Question. When you define a field for a table, which of the following parameters do Access always consider optional?
(a) Field Name
(b) Data Type
(c) Field Size
(d) Description
Answer: (d) Description field of table is optional, as it depends on database designer that he/she wants to describe field or not.

Question. A command tab which allows to create the table in an interactive manner is called
(a) Home
(b) Table
(c) Form
(d) Create
Answer: (d) MS-Access provides a command tab named Create which allows to create the table in an interactive manner.

Fill in the Blanks 

Question. Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs.
Answer: templates

Question. In a table, columns are called ………. and rows are called ………… .
Answer: fields, records

Question. The different objects supported by MS-Access are tables, queries, ………… and reports.
Answer: forms

Question. The ………….. field property makes data entry compulsory, so that the field cannot be left blank.
Answer: Required

Question. To store object like image, you need to create a field in a table, having field type as…………. .
Answer: OLE Object

Question. …………. is a field which is used as a primary key and numbers each record sequentially.
Answer: AutoNumber

Question. For storing lengthy information in a field ………….. data type is used.
Answer: Memo

Question. In a Text type data field, we can enter a maximum of ………….. characters.
Answer: 255

True or False [1 Mark each]

Question. When you open a database, the Ribbon appears on the left side of the MS-Access 2007 window.
Answer: False Because ribbon appears on the top of the window.

Question. A Text data type cannot allow number entry.
Answer: False As, it can include both text as well as numbers.

Question. Memo data type allows you to store character type values in a table.
Answer: True Memo data type allows upto 65536 characters.

Question. Memo data type allows you to store only 255 characters in the table.
Answer: False Memo data type is used when character size is more than 255.

Question. The Datasheet View displays the data in a table in tabular format. 
Answer: True A datasheet is a simple view of data arranged in rows and columns.

Question. Design View allows users to enter data in the table.
Answer: False Because Design View is used to edit the table design only.

Question. A query is used to retrieve data from the database based on one or more criteria. This database object is not supported by MS-Access 2007.
Answer: False Because MS-Access 2007 supports the database object query.