What does the Field Size property do?  What is the default field value for Text fields, and why would you want to change it?  What is the default field value for Number fields, and why would you want to change it?

What will be an ideal response?

(Answers may vary)
The Field Size property sets the number of characters you can store in a Text, Number, or AutoNumber field.

For Text fields, the default value is 255 characters. This means that every field value must contain 255 or fewer characters. You can change the Field Size property for a Text field to store fewer characters. For example, if you create a field that stores state abbreviations, you might set the Field Size property to two characters, because all state abbreviations contain two characters. This change will ensure that no one can enter a three-character state abbreviation, which would be an incorrect field value.

For Number fields, the Field Size property uses a different way of expressing the length. The default Field Size property for a Number field is Long Integer, which stores very large positive and negative whole numbers. Other field sizes for Number fields store numbers with decimals (such as 101.24), positive whole numbers only, and numbers that are less than or equal to 255.  An example of changing the field size would be if you wanted to limit the space where a zip code can be entered, or if you wanted to include decimal places for entering dollar amounts.

Computer Science & Information Technology

You might also like to view...

What is a next hop address?

a. Another name for the default gateway address b. The IP address of the next networking device that can be used to forward the data packet to its destination c. The IP address of the next networking device that can be used to forward the data packet to its source d. It does not have a purpose in routed networks.

Computer Science & Information Technology

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology