Chapter 4 Microsoft Access Solutions
Question - 1 : - What is the default extension of a MS-Access database?
Answer - 1 : - 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 - 2 : - 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 - 3 : - Assets, Contacts, Events, Faculty and Issues.
Question - 4 : - Give the names of five data types used in MS-Access.
Answer - 4 : - Text, Memo, Date/Time, Yes/No and Currency.
Question - 5 : - What happens when text is entered in a Number type field?
Answer - 5 : - 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.”
Question - 6 : - Is it necessary to define a field type for a field in MS-Access?
Answer - 6 : - Yes, it is necessary to define a type of a field while entering data into a field.
Question - 7 : - Which field property sets limits on the data that is entered?
Answer - 7 : - Fixed Field Length or Field Size property sets the limits on the data entered.
Question - 8 : - What is the use of AutoNumber type field used in MS-Access?
Answer - 8 : - 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.
Question - 9 : - What are the views in which fields can be deleted in MS-Access?
Answer - 9 : - Datasheet View and Design View.
Question - 10 : - Explain field length with its types.
Answer - 10 : -
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:
1. Fixed length field It is a type of field length in which the number of characters you enter in a field is fixed. These are present in Format option in Data Type Formatting group (in Datasheet tab) such as Currency, Euro, Percent etc.
2. Variable length field In this type of field length, the number of characters is not fixed. Actually, the number of characters of the data entered in the field decide the field length.
The field length or field size of each data type are as follows: