0
A field is essentially the columns of the table on the database.
The size of this depends on what you intend placing in each "box". I.e. a first name field would be set up for 20. This will allow 20 characters in that "box" and each box thereafter. A last name field might have 30 character's, a telephone for a mobile phone for example might need 11 (as most mobile phones use a 11 digits) however, a programmer may "future proof the database by allowing up to 20 characters in that box just in case numbers increase as more phones are used.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
Does Access allows you to change a field's size in Datasheet view?
yes,it does
How can show the euro instead of the dollar sign on access?
change the field size
Is it true or false that certain Access data type have a predefined field size that cannot be changed?
The Field Size Property defines a field values maximum storage size for Text, Number, and AutoNumber fields only. The other data types have no Field Size property because their storage size is either a fixed, predetermined amount or is determined automatically by the field value itself.TRUE
When using Microsoft Access what is the default field size for a text field?
for 2003? i believe it is 255 characters. not positive though... (I use Access quite a bit, however, I am still not sure of that number)
When creating a table every field in access must have what two things associated with?
Every field must have a name. They also must have a data type. For some field types, you also need to have a size, though a default size will be set for those fields.
When creating a table every field in Access must have what two things associated with it?
Every field must have a name. They also must have a data type. For some field types, you also need to have a size, though a default size will be set for those fields.
How do you see the field size and or caption for a field in Access?
Go to Design View for the table. Click on the particular field. Then look at the properties of the field and you will see the size and caption. Some data types have fixed sizes, like dates and times, while others you can set yourself, like Text.
How do you describe Field in a field of Microsoft Access?
rado
Access automatically adds a field called as the first field in the table?
key field
What are the consequences of changing a field size in a database?
what are the consequences of changing a field size
What is a database field size?
Field size defines the maximum number of characters or numbers that a particular field can hold
What is a field that stores the value of mathematical operation in access?
A Calculated Field
