1.

Explain field length with its types.

Answer»

It refers to the maximum number of characters that a field can contain. Each character requires one byte for its storage. 

Field length is of two types which are as follows: 

1. Fixed length field It is a type of field length in which the number of characters you enter in a field is fixed. These are present in Format option in Data Type Formatting group (in Datasheet tab) such as Currency, Euro, Percent etc.

2. Variable length field In this type of field length, the number of characters is not fixed. Actually, the number of characters of the data entered in the field decide the field length.

The field length or field size of each data type are as follows:

Data TypeField length or Field sizeData TypeField length or Field size
Text0-255 charactersMemo0-65,536 characters
Number1,2,4,8 or 16 bytesDate/Time8 bytes
Currency8 bytesAutoNumber4 or 16 bytes
Yes/No1 bit(0 or 1)OLE ObjectUpto 2 GB
HyperlinkEach part contains upto 2048 charactersLookup Wizard4 bytes



Discussion

No Comment Found