For a field with Short Text as its data type the following field properties have been set. Answer the following questions.
1. What is the effect of setting the Field Size property as 20? What is the default value for this property for Short Text data type?
2. What value will appear on its own under this field whenever a new row of data is inserted in the table? Is the user allowed to change this value?
3. What will happen when the user enters the value "Science" in this field at the time of data entry?
4.What happens when the required property is set to "Yes" and allow Zero length property is set to "No" for this field?
please give right answer of this question otherwise I ___ your mother
Answers
Answer:
A field's data type determines many other important field qualities, such as the following:
Which formats can be used with the field.
The maximum size of a field value.
How the field can be used in expressions.
Whether the field can be indexed.
A field's data type can be predefined or you will select a data type depending on how you create the new field. For example, if you create a field from the Datasheet view and:
Use an existing field from another table, the data type is already defined in the template or in the other table.
Enter data in a blank column (or field), Access assigns a data type to the field based on the values that you enter or you can assign the data type and format for the field.
On the Modify Fields tab, in the Fields & Columns group, click Add Fields, Access displays a list of data types that you can select from.