Data Types of Ms Access

1)     What is data type?
Ans: Data type is an attribute for a field that determines what type of data it can contain.

2)     Write any four data types of MS-Access.
Ans: Any four data types of MS-Access are:
i) Text
ii) Number
iii) Memo
iv) Currency

3)     List any four types of field properties used by MS-Access.
Ans: The four types of field properties of MS-Access are:
i) Caption
ii) Format
iii) Validation rule
iv) Input mask

4)     Define the term of input mask and relationship.
Ans:
Input mask: Input mask is a field property that controls the value of a record and sets in a specific format.
Relationship: Relationship is an association among several entities (table).

5)     What is caption?
Ans: Caption is a field property which displays an alternate name for the field to make the field name more explanatory. It can contain up to 2048 characters.

6)     What is validation rule? Define validation text.
Ans:
Validation rule: A field property which enables to limit values that can be accepted into a field is known as validation rule.
Validation text: A field property which allows type text to be displayed if the user input value is prohibited by the validation rule is known as validation text.

7)     Differentiate between text and memo.
Ans:

Text	Memo
i) It is used for storing text or combination of text and numbers.	i) It is used for storing lengthy text and numbers.
ii) It can store up to 255 characters.	ii) It can store up to 65,535 characters.

8)     What is field size? What is the use of ‘Format’ field property?
Ans: Field size is a field property that set the maximum size for the data stored in the field set to the text or number data type.
The use of ‘Format’ field property is to display the data in a different format.

9)     Write down the use of Lookup Wizard and Hyperlink data types.
Ans: The use of Lookup Wizard is that it creates a field that allows choosing a value from another table or from a list of values by using a list box or combo box.
The use of Hyperlink is that it stores hyper like addresses like email addresses, websites, database objects or other field.

10) Define indexing. Mention its types.
Ans: Indexing is one of the important properties of database that speed up searching and storing of records using on the field.
Its types are:

·       Primary indexing

·       Secondary indexing

·       Clustering indexing

11) Define relationship with its types.
Ans: Relationship is an association among several entities (table).
Its types are:
i)One to one relationship
ii)One to many relationship
iii)Many to many relationship

12) What is referential integrity?
Ans: Referential integrity is a set of rules used by RDBMS to make sure that the relationships between tables are valid and that the related data is not accidentally changed or deleted.

13) Define field.
Ans: A column in a table is called field, and it contains a specific piece of information within a record.

14) Differentiate between field and record.
Ans:

Field	Record
i) A column in a table is called field, and it contains a specific piece of information within a record.	i) Record is a collection of multiple related fields in a row which gives complete information about a person or thing.
ii) E.g.: Name, Address, Telephone	ii)E.g.: Ram Chabahil 4468790

15) While designing table structure which data types are suitable to store information about teacher’s name, address, salary and date of birth.
Ans:
Teacher’s name - Text
Address – Text
Salary – Currency
Date of birth – Date/Time

What happens when we enter text in a numeric field?
Ans: If we enter text in a numeric field then it displays the error message.