1-866-245-5224 sales@keystonelearning.com

Access 2007: Creating a Table in Design View

Access 2007: Creating a Table in Design View

When you create a database, you store your data in tables — subject-based lists of rows and columns. For instance, you might create a Contacts table to store a list of names, addresses and telephone numbers, or a Products table to store information about products. You should always start the design of a database by first creating its tables — even before you create any other database objects.

Creating a Table in Design View

     
  1. Open any database
     
  2.  
  3. Choose the Table Design command in the Tables group on the Create tab
     

Figure 5. Table Design View

    3.       In the first cell in the first row, enter a field name

    4.       Press [Tab]

    5.       Choose a Data Type from the Data Type drop-down list

    6.       Press [Tab] twice

    7.       Enter your next field name

    8.       Continue with steps 4 through 7 until all fields have been entered and properly assigned a data type

    9.       Click the Save command on the Quick Access Toolbar

 

Figure 6. Table Save As Dialog Box

 

    10.   Enter a table name

    11.   Click OK