Creating a Simple Table
As an example, we will use a simple table of supplier names and sizes of supplier. Create a
table by clicking Create in the Access menu and then clicking the Table Design icon in the
Tables group of the ribbon. Add in three text fields: SupplierName, SupplierSize, and
SupplierRef.
Your table design window should now look like Figure 39-1.
Save the table astblSupplier. There is no need for a primary key. Populate the table with
some data—the SupplierSize field should be Small, Medium, or Large. Your data for the
table should resemble Figure 39-2.350 Microsoft Access 2010 VBA Macro Programming
Figure 39-1 The table design window for the supplier table