SOLVED QUESTION ANSWERS
MS-ACCESS
CLASS-X
1. Explain the term validation rule and validation text?
Ans. A Validation Rule limits or controls what users can enter in a table field or a control (such as a text box) on a form.
For example, entering a rule such as >100 And <1000 in the Validation Rule property forces users to enter values between 100 and 1,000.
Validation text is a specialized error message you can set to have Access tell the user entering data the specific way you want that person to enter it. This property is related to the Validation Rule property and is used to specify an error message that will be displayed in case the validation rule is not satisfied.
2. What is the use of setting input mask?
Ans. Input mask property is used to control how the data is entered when you have several people entering data in your Access database to help maintain consistency and to make your database easier to manage. For example, you can set an input mask for a form so that users can only enter telephone numbers in the Swedish format or addresses in the French format.
3. How is input mask different from format?
Ans. The format property controls the way your data in the field will be displayed whereas input mask controls how the data is entered in a specific field or form.
4. What do you done by validation? Name two levels at which this is done.
Ans. Validation/data validation is a method of ensuring that the data is entered into the table is correct and conforms to certain limits and format sets.
The two levels of data validation are:
1. Field level validation
2. Record level validation
5. What is record validation?
Ans. In record validation, the values can be compared in more than a single field when the record is saved.
6. What should be the setting of required and allow zero length if you want to prevent users from leaving a field blank?
Ans. Required ---- yes
Allow zero length----- no
7. The decimal places property can be set for which type of field is done?
Ans. Number or Currency type.
8. What is a query?
Ans. Query are use to retrieve information or perform actions based on some conditions . It is like to ask question.
9. What are the different types of number format that can be set?
Ans. The various types of number formats are:
1. General number
2. Currency
3. Euro
4. Fixed
5. Standard
6. Percent
7. Scientific displays
10. What methods can be used to create a value list?
Ans. By using list box and by using combo box.
11. Name the data types in which the field property allow zero length is available in ms-access.
Ans. Text, memo and hyperlink fields
12. What are the different Number field types in Access?
Ans. The different number field types are:
Byte, Integer, Long Integer, Single, Double
13. What is the meaning of following field properties?
Field Size, Format, Input Mask, Caption, Decimal Places, Default Value,
Validation Rule, Validation Text, Required, Allow Zero Length, Indexed.
Ans. Field properties and their meaning are described below:
1. Field Size: Maximum number of character or value you can enter in field
2. Format: Format for the field. It gives the layout for the field.
3. Input Mask: A way or pattern of data to be entered.
4. Caption: The label for the field
5. Decimal Places: The number of digits to the right of decimal place.
6. Default Value: The value automatically entered for the new record.
7. Validation Rule: An expression that limit the value to be entered in the field.
8. Validation Text: The message to be displayed while user violates the rule when entering
data.
9. Required: The data should be entered the field can't be left blank.
10. Allow Zero Length: Permits zero length of string
11. Indexed: The field is to be indexed. Indexing speeds up the searching & sorting
14. What is Lookup Field?
Ans. A Field that stores a list from an existing table or query or a fixed set of values that is looked up.
15. What do you mean by default value for a field in Access table?
Ans. Default value specifies the value that must be displayed in a particular field when making the data entry. For example you can specify 'Nepal' for the Country field. When entering record the value 'Nepal' will appear automatically and can be modified if required.
