When you need to make a number of quick changes to your
database, the Alter Table command can help. You can use the command to quickly
add or delete fields in a table.

For example, to add a new Mobile_Phone
field to the Employees table, follow these steps:

  1. Open
    the database containing the Employees table, then click Queries in the
    objects list in the database window.
  2. Click
    New, Design View, and OK.
  3. Click
    Close.
  4. Go to
    Query | SQL Specific | Data Definition.
  5. Enter
    the following statement:
    ALTER TABLE Employees ADD COLUMN Mobile_Phone
    TEXT
  6. Click
    Run.

You can verify that the field was added by opening the
Employees Table in Design View. To delete a field, you would use the following
statement:
ALTER TABLE Employees DROP COLUMN Mobile_Phone.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.