Access Data Types

Specifying field data type

• Text : A text field can stores any alphanumeric characters up to 255 characters (texts, numbers, punctuations, and symbols). Ex. Names, address, phone numbers, product descriptions, and etc.

• Memo : A memo field can stores large amounts of text up to 65,535 characters. Ex. Memos, articles, letters, short documents, and etc.

•  Number : A number field can store different kinds of numbers, including negative and decimal numbers.

• Date/Time : A date/time field can stores date, time and both (date and time).