difference between Text (fix) [CHAR] and Text [VARCHAR].

Q3. What is the difference between Text (fix) [CHAR] and Text [VARCHAR]?

Ans. The differences between the Text (fix) [CHAR] and Text [VARCHAR] data types are as follows:

 

Text (fix) [CHAR]

Text [VARCHAR]

Represents a text data type of fixed length. Represents a text data type of variable length.
If the data that you enter is less than the length specified, then the field is completed by trailing spaces. If the data that you enter is less than the length specified then the field is not completed by trailing spaces.

 

 

 

How can you move a field in a table in Base?

Q2. How can you move a field in a table in Base?

Ans. Generally, moving a field means changing its position in a table.

To move a field, you have to first cut the field from its location in the table by using the Cut command and then paste the field in the desired location by using the Paste command. In BASE, when you move a field, it appears as the last field of the table.

Data validation and How can you use data validation in BASE.

Q1. What do you understand by data validation? How can you use data validation in BASE?

Ans. In a database, data validation refers to a process of ensuring that only valid data is entered in a table. You can ensure data validation by setting the field properties of your tables such that only valid data can be entered by the users. For example, if you set the Yes value for the Entry required property, it will ensure that users enter some value in this field during data entry. However, if you specify No as a value for this field, then the user can skip this field.