Tree View
Tree
List View
Alphabetical List
Share
Share
Search:
id:
42

name:

Datatype



description:
A datatype is a type of data. Some data types include currency, decimals, text, date/time, yes/no and look-up tables. Choosing a datatype allows you increase data accuracy by restricting which kind of information users can enter when they are creating new records.

Data Accuracy


Choose a datatype that accurately describes which type of data a field will contain will make your application more efficient and less error-prone. It will also make any reports and charts you generate more precise. Think carefully about which datatype is most appropriate for your field. If you create a field called HireDate in your Employees table, choose the datatype date/time, users will only be able to enter properly formatted dates. If you chose a less specific datatype, such as Multi-line text, employees could enter the entire story of how they were hired in the HireDate field.


ParentTopic: