Entry Required field property.

Q13. What do you understand by the Entry Required field property? Explain with a suitable example.

Ans. The Entry required specifies whether the entry of data in the selected field is mandatory or not. For example, in case you set the value as Yes in the field property of a selected field, it means that you must enter data in the field. On the other hand, if the value is set as No, then you need not enter any data in the field. Read More …

Field properties in Base.

Q10. What do you understand by field properties in Base? Explain the various types of field properties available in Base.

Ans. In a database, field properties play an important role in controlling the behavior of a field. In BASE, you can assign the following types of field properties:

  • Entry Required: Specifies whether the entry of data in the selected field is mandatory or not. For example, in case you set the value as Yes in the field property of a selected field, it means that you must enter data in the field. On the other hand, if the value is set as No, then you need not enter any data in the field. In other words, you can skip this field. Read More …

Define field length in database.

Q6. Define field length with the help of an example.

Ans. Field length helps you specify the size of the field in a table. For example, if you specify 2 as the field length for a numeric field, it means that the field can store values from 1 to 99, which is the maximum value that can be written in two digits.

Explain fields in a table of database.

Q4. Explain fields in a table with the help of a suitable example.

Ans. A field is a column that contains similar type of data. For example, there is a database named Student and it has a table named Student_Details. In the Student_Details table, the St_Name, St_RollNo, St_ContactNo, and St_Address are the names of the fields.