Tables

Tables are the storage containers for data.  The container houses your data (rows) and describes your data through its properties (fields or columns) much like an object in your home.  An example:  Say you want to store information about a chair, First thing we will do is create our table, we will call it tblChair (tbl is short for Table - No pun on the Table/Chair intended).  Table chair must now contain information about our Chair(s).  We will create columns within our table to describe the properties of our Chairs.  nID, nLegs, strColor, strSize, strType, nWeight.  These all describe the ID Number (nID), Number of Legs (nLegs), the color (strColor), the size (strSize), the type of chair (strType) and the weight (nWeight).