Question

What is the most suitable data type for a telephone number field in a table?
a) Text b) Date
c) Number d) Memo

Answer 1

The most suitable data type for a telephone number field in a table is c) Number.

Telephone numbers are numerical values and therefore should be stored as a numeric data type, such as the Number data type in Microsoft Access or the Integer or Long Integer data type in other database management systems.

Storing telephone numbers as numeric data types allows for easier sorting and searching of the data, as well as more efficient use of storage space.

• Using a text data type (option a) to store telephone numbers can lead to data entry errors, such as entering letters or special characters, which can make it difficult to sort or search the data accurately.

• A date data type (option b) is not appropriate for telephone numbers, as they do not represent a date or time value.

• A memo data type (option d) is used for storing large amounts of text, such as notes or comments, and is not appropriate for storing telephone numbers.

To know more refer :-

https://brainly.in/question/6748036?referrer=searchResults

https://brainly.in/question/17180725?referrer=searchResults

#SJP1