Modifying a Table

It’s easy to create tables in Access, but you’re not stuck with the first version of a table. After you create a table, you can modify it by adding, deleting, and reordering fields. Although the order of your fields doesn’t affect how your table functions within the database, changing their order can make it easier for you and your colleagues to understand your table’s structure

Change a Table

  1. Right-click the table you want to modify.

  2. Click Design view.

  3. Follow any of these steps:

    1. To delete a field, click the row selector of the row you want to delete, click the Delete Rows button, and then click Yes to confirm that you want to delete the row.

    2. To add a field, click the row selector of the row below where you want the new field to appear, click the Insert Row button, type a name for the field, click the row’s Data Type cell, click the down arrow that appears, and then click the desired data type.

    3. To reorder the fields in your table, click the row selector of the row you want to move, and then drag the row selector to the desired position.

    Change a Table
    Change a Table
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset