Step 3: Create required fields
After you selected the table you can create the related fields based on your requirements and initial design..
Currently you can choose the following datatypes:
| Type | Description |
|---|---|
| Date | Denotes a date ranging from January 1, 1753 to December 31, 9999. |
| Time | Denotes a time ranging from 00:00:00.000 to 23:59:59.999. An undefined or blank time is specified by 0T. |
| DateFormula | Represents a date formula that has the same capabilities as an ordinary input string for the CALCDATE Method (Date). The DateFormula data type is used to provide multilanguage capabilities to the CALCDATE Method (Date). |
| Decimal | Denotes decimal numbers ranging from -999,999,999,999,999.99 to +999,999,999,999,999.99. |
| Text | Denotes a text string. |
| Code | Denotes a special type of string that is converted to uppercase and removes any trailing or leading spaces. |
| Boolean | Indicates true or false. |
| Integer | Stores whole numbers with values that range from -2,147,483,647 to 2,147,483,647. |
| DateTime | Denotes a date and time ranging from January 1, 1753, 00:00:00.000 to December 31, 9999, 23:59:59.999. An undefined or blank DateTime is specified by 0DT. |
More info:
Microsoft Data Types and Methods
When finished click next.
