Microsoft Access Data Field Type

Database Hierarchy:

• Database
• Table
• Field / Column / Attribute
• Record / Row / Instance
• Value / Fact

Table Field's Data Type / Table Field's Property

• Text
• Hyperlink
• Number
• Long Integer
• Double
• Currency
• Date/Time

Table Data Type sample:

Text: Teddy
Hyperlink: http://www.websitecompany.com/
Byte (General Number): 420
Byte (Currency/Euro, new from 2007): $308 or $308.00

Long Integer (General Number): 1l3482
Long Integer (Currency): 34,000
Long Integer (Fixed): 34000.99 (default is 2 digit decimal places)
Double: 34,000.9
Double (Currency): $49.40
Date/Time (General Date / Short Date): 12/39 , dd / yy or mm / yy result: 12/1/1939
Date/Time (Medium Date): 12-Jan-39
Date/Time (Long Date): Thursday, January 12, 1939
Date/Time (Long Time): 12:00:00 AM
Date/Time (Medium Time): 12:00 AM
Date/Time (Short Time): 00:00

Field Type:
Replication ID: has not a format, need more resource to process, avoid when using to primary key.

referensi:
codeschool
coursera
support.office.com
udemy
university:
Aarhus University
Austria’s Technische Universität Wien (Vienna University of Technology
Cairo University
Georgia Institute Of Technology
Indian Institute of Technology Delhi.
Israel Institute of Technology
KAIST - Korea Advanced Institute of Science and Technology
Kyoto University
Latin America Universidade de São Paulo (USP)
Nanyang University of Technology (NTU)
Politecnico di Milano
Pontificia Universidad Católica de Chile and the Universidad de Chile
Saudi King Fahd University of Petroleum & Minerals (KFUPM)
Shanghai Jiao Tong University
South Africa
Stanford University
The University Of Cape Town
The University Of Copenhagen
The University Of Edinburgh
The University Of New South Wales
Trinity College Dublin (TCD)
Tsinghua University
Universidade de São Paulo (USP)
Universidade Estadual de Campinas (Unicamp)
Universiti Malaya
University of Auckland