Table data type

In MS Access, Table is the main root of a database. You have to know how many data types in MS Access and what their task. In this section I’ll try to describe all the data types. For build a powerful and accurate database you should have to use appropriate data type for appropriate field.
  MS-Access Data Type
Data type Use for
Text Use for text only
Memo Text and number both
Number Number only
Date and Time Date and time
Currency Currency (Dollar,Euro,etc)
Auto number Auto numbering like 1,2,3,…
Yes No True or Flase
OLE object Link imgae,sound,file etc
Hyperlink Heyperlink
Lookup wizard Create Your won

Example table : It will help you to understand better

data types of ms access,ms access

Ms access table data types

Share on :

Leave a Reply

+ two = 8