answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: Why some fields that store only numbers have a text data type?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Math & Arithmetic

Define fixed length fields?

Fixed length fields are columns in a database table that always use a set amount of space for each row of data in the table. A fixed length field of 50 characters will always consume 50 characters for that field, regardless of how long the actual data in that field requires. Fixed length fields typically use more storage resources than variable length fields, but they are a bit faster for the processor to work with, since the length only needs to be determined once. Fixed length fields are appropriate for data where the length is constant. Some examples of fields that are good candidates for fixed length fields include Social Security Numbers, fixed length postal codes/ZIP Codes and telephone numbers (provided international data is unexpected.) Data that varies in length should be stored in a variable length field, as it will take less physical storage space and will not need to be truncated to remove extra spaces.


Give an example of a database field?

This is a very simple explanation. A database is a collection of schemas. A schema is a collection of tables. A table is a collection of possibly unlimited rows organized into fields or more commonly called columns. Think of a spread sheet. For example an inventory table might have columns ITEM_NUMBER, ITEM_NAME, and ITEM_QUANTITY. ITEM_NUMBER is defined to store only whole numbers ITEM_NAME is defined to store only letters and numbers up to the length of 20 ITEM_QUANTITY is defined to store only whole numbers Here is some possible sample data ITEM_NUMBER * ITEM_NAME * ITEM_QUANTITY 1001 * Washer Brass * 5044 1002 * Screw 4x40 stainless * 5027 1003 * Screw 6x40 stainless * 4947 So, to answer your question, a database column (or field) belongs to a table and has attributes that describe the column and what can be stored in the column.


Can the median in a set of data be the greatest number?

Only if all values in the dataset are equal. Otherwise, it is impossible. If there are two numbers in the dataset, the median is the average of these two numbers. If there are three numbers, then the second number is the median or one number away from the maximum.


What is the relation between access and database?

Access is no security Database has security limited data can store in access we can specify the size and file growth. we can store n number of data's only primary key can specify in access. but in database we can specify primary key as well foreign keys and other keys.


Difference between bar code and qr code?

Bar code stores numbers only,but QR code can be store be with any multimedia.

Related questions

How can you dicribe array?

An array is when you store several data items with a single name. You only use a number to distinguish the individual items. Or two or more numbers, if you use a multidimensional array.An array is when you store several data items with a single name. You only use a number to distinguish the individual items. Or two or more numbers, if you use a multidimensional array.An array is when you store several data items with a single name. You only use a number to distinguish the individual items. Or two or more numbers, if you use a multidimensional array.An array is when you store several data items with a single name. You only use a number to distinguish the individual items. Or two or more numbers, if you use a multidimensional array.


The monetary data type is used for fields that contain only monetary data?

FALSE


What does a computer store data only or data and information only?

food


What is alphanumeric or text database?

A field of this data type will accept both numbers and text. The alphanumeric keys are the part of the deyboard that looks like a typewriter. When to use - it you want to enter text, or a mixture of text and numbers. When NOT to use - if you want to store only munbers, or only dates. You can enter numbers or dates into text fields but they would get sorted as if they were words and could not easily be used for any calculations.


What is the data includes only numbers?

Quantitative data


Do computers store data digitally and ultimately as a stream of only two numbers?

Most digital computers today do.


What can only have value by counting numbers?

Data


Is A query datasheet is called a logical view of the data because a query does not physically store the data as it is still stored in the tables?

Queries do not store data, they only display a view of data.


Difference between text field and memo field?

Memo fields can store up to 1 gigabyte of characters or 2 gigabytes of storage (2 bytes per character), of which you can display 65,535 characters in a control on a form or report. In addition, you can now apply rich-text formatting to the data in a Memo field. For example, you can set colours, change fonts, and make data bold or italic. Fields of memo data type cannot be grouped while filtering and it is not possible to sort them however, they are searchable. It is not possible to add a look up property to a memo field. It is also not possible to set an input mask to a memo field meaning that the user can input data however they want without an input mask to guide them as to what format to input the data in. Text field are for plain text or combinations of text and numbers, such as addresses. Also numbers that do not require calculations, such as phone numbers, part numbers, or postal codes. Text fields may store up to a maximum of 255 characters. Microsoft Access only stores the characters entered in a field; it does not store space characters for unused positions in a Text field. To control the maximum number of characters that can be entered, set the Field Size property. You can and should define a width, but Access doesn't use fixed width storage so is not as wasteful of disk space. Text fields may have look up properties to link them to other fields if necessary.


Define fixed length fields?

Fixed length fields are columns in a database table that always use a set amount of space for each row of data in the table. A fixed length field of 50 characters will always consume 50 characters for that field, regardless of how long the actual data in that field requires. Fixed length fields typically use more storage resources than variable length fields, but they are a bit faster for the processor to work with, since the length only needs to be determined once. Fixed length fields are appropriate for data where the length is constant. Some examples of fields that are good candidates for fixed length fields include Social Security Numbers, fixed length postal codes/ZIP Codes and telephone numbers (provided international data is unexpected.) Data that varies in length should be stored in a variable length field, as it will take less physical storage space and will not need to be truncated to remove extra spaces.


Data type where a field can only contain numbers?

Number


How do discrete and continuous data relate to quantitative data?

discrete data can only be whole numbers whereas continuous can be fractions decimals don't necessary have to be counting numbers as we know them. 1,2,3...