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 ...

Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.