Diy Canoe Building Plans Meaning

NCERT Solutions for Class 10 Foundation of Information Technology - Microsoft Access - Learn CBSE
All class 10th revision notes are prepared as per CBSE NCERT syllabus.� Chapter 13 - Magnetic Effects of Electric Current: Our 10th Science Notes cover all the significant topics like magnetic field and field lines, the force on current-carrying conductors, etc. It also covers electric motors, electric generators and domestic electric circuits in a detailed way. Chapter 14 - Sources of Energy: The crucial notes cover all the topics like energy, fossil fuels, conventional sources of energy and more. NCERT Class X Information Technology Book National Council of Educational Research and Training (NCERT) Book for Class X Subject: Information Technology.� Class X NCERT Information Technology Text Book is given below. Click Here to download above PDF. Class X All NCERT Books. To get fastest exam alerts and government job alerts in India, join our Telegram channel. Jan 12, - NCERT Textbook -Network Security, Information & Computer Technology Class 10 Class 10 Notes | EduRev is made by best teachers of Class This document is highly rated by Class 10 students and has been viewed times.

Question 1. What is the default extension of a MS-Access database? Answer: The default extension of a MS-Access database is. Question 2. Give any one difference. Question 3. Give five names of database templates used in MS-Access Question 4. What happens when you enter numbers in a Text data type field? Question 5. Question 6.

Give the names of five data types used in MS-Access. Question 7. What happens when text is entered in a Number type field? Question 8. 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 9. Write one example of data for which Memo data type is used. Question Which field property sets limits on the data that is entered? CBSE 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.

Which field property specifies whether the field can be left empty when entering data into a record? What are two areas of the Design View of the table? What happens, if you do not enter a caption for a field? Answer: In this case, Field Name is used as a label. If the data type of a field is set to Text, what will be its number range? Answer: Its range will be 0 to What are the views in which fields can be deleted in MS-Access?

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. What are the commands contained by Create tab? How will you create a blank database in MS-Access ? Answer: Creating a Blank Database To create a new blank database, you need to perform the steps which are as follows:.

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:. What are Datasheet View and Design View? Answer: In MS-Access , two types of views are available to create a table as follows:. Write down the steps to insert a new row into the table. How can you delete an Access table from a database? Answer: Steps to delete a table are as follows:.

When Memo data type is preferred over Text type for a field? Text data type is not capable to store the project description because its length can not be more than characters so, Memo data type is preferred over Text data type. Distinguish between Text and Memo data types.

Explain with the help of an example. When is AutoNumber data type preferred over Number data type? CBSE 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. 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. Write one example of data field for which you would set the Required property to Yes? What is the purpose of Default Value field property? Then, to avoid typing the same thing many times, you can set as a Default Value property. 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. What is a primary key? How do we set a primary key? CBSE , 06, 05, 04, 03, 02 or Define primary key. How do you set it in MS-Access? CBSE 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. Give any one difference between freezing a field and hiding a field. CBSE , 02 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 [5 Marks each]. What is database template? Give the description of five templates, used in Microsoft Access 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. Explain MS-Access Ribbon. Answer: The Ribbon contains a series of command tabs. In MS-Access , the main command tabs are as follows:. Write one example of each field, for which you would use CBSE , 06, Distinguish between Number and AutoNumber data type field.

Give example of each. Which field properties are used in Office Access ? 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:. Validation Text This appears if a validation rule is not satisfied. Same as validation rule.

Required Makes data entry compulsory, so that field can not be left blank. Indexed To speed up queries, sorting and grouping operations or to prevent users from entering duplicate values. Smart Tags Attaches smart tag to the field. Text Align Specifies the alignment i. Application Oriented Questions. Pronita is a programmer in an institution and is asked to handle the records containing personal information of the teachers teaching in the institution.

Conclusion:

All of a outboard maunfacturers operate a same reduce sectionAffinity engineer is a quickest. A essay took place as the outcome of I seen opinions upon what creates the great cruising vessel talk about regionally. Yeah, though what could be really probable as well as standard is which your mattress is 6, I did in truth go together with a Wa'apa pattern as well as accomplished a hulls however haven't gotten a vessel inside of a H2O. 10th ncert information technology values is an additional customary bend since of the application !

Harbor Craft Aluminum Boats Uk Class 10th Physics Ncert Book Day The Fishing Boat Menu Emersons Green Judge