6.Maximum size used by Date/Time data type isRequired to answer.Single choice.
Answers
Answer:
Question 1. What is the default extension of a MS-Access database?
Answer: The default extension of a MS-Access database is .accdb.
Question 2. 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 3. Give five names of database templates used in MS-Access 2007.
Answer: Assets, Contacts, Events, Faculty and Issues.
Question 4. What happens when you enter numbers in a Text data type field? CBSE 2008
Answer: Numbers are accepted as a text values.
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.”