Question

Q.2 State True or False
a) A set of various records is called a field.
b) Short Text can store up to 255 characters.
c) Navigation Pane is used to navigate through the records.
d) OLE Object can store up to 2 GB of data.
e) RDBMS stands for Rotational Database Management System.
f) MS Access provides two ways to create a query.
g) To execute the query you need to press the Execute button on the Query
Tool Design tab.
h) Filter option can only filter the data of one table.
i) Primary key does not allow duplication of data.
i) Queries cannot draw information from multiple tables,​

Answer 1

Explanation:

true false true false true

Answer 2

Answer:

Question 5. Name the data type that should be used to store Student’s Admission numbers.

[Examples of Admission number; S100, S101, S102] CBSE 2008

Answer: Data type should be Text.

Question 6. Give the names of five data types used in MS-Access.

Answer: Text, Memo, Date/Time, Yes/No and Currency.

Question 7. What happens when text is entered in a Number type field? CBSE 2005

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.”