(Model Paper) Download CBSE Class X Information Technology Paper(2010)

1) Answer the following questions:-
a) What is the default extension of Ms-Access database?
b) Distinguish between a record and a field in a table, with an example.
c) How do we set a primary key in Ms-Access?

Write one example of each of fields for which you would use
(i) Text data type and  (ii) Memo data type 
What is the purpose of “Default value” field property?
Which field property specifies whether the field can be left empty when entering data into a record?

Define the term “Data Validation”. Write a validation check to have a value less than 10000 in a data field “Basic Salary” (Basic Salary is a numeric field?...[..]