Creating Table

Thursday, November 18, 2010
Tables used for data storage media, should be well organized table, the table must have indexes to facilitate the search data. There are times when the index consists of one or more fields.
  
Click table button on the left side as shown below ;

















Click Link Create Table in Design View for creating table; 
Insert field which is representative for that table like structure below
  1. sales_number
  2. revision_number
  3. sales_status
  4. customer_code_orig
  5. cco_name
  6. reference 
Each field must have measurement or can be called length of data, and also type of data storage, there is a lot data type such as
  • Text for Character
  • Number for Nominal and can be count 
  • Memo for large number of character
  • Date / Time for Date / Time
  • and etc
For this case we use text data type









0 comments:

Post a Comment