Modifying Data in Tables

See Also   Tasks

In addition to viewing the contents of tables, you can use the Query Designer to modify data in tables by editing the contents of columns, adding new rows, and deleting existing rows. Using the graphical features of the Query Designer, you can modify data in tables two ways:

Note   If you are familiar with SQL, you can also execute any statement in the SQL pane, including those that update or delete data in tables. The features discussed in this section relate primarily to capabilities that are available by using the Diagram, Grid, and Results panes.

Editing directly in the Results pane is similar to editing in a form or spreadsheet. You can see the changes immediately, and if there is a problem (for example, you attempt to enter data that does not match the data type of a column), you are notified as soon as you try to move to another row. For details, see Editing Rows in the Results Pane.

On the other hand, even though it is not as simple, creating a query to update, delete, or copy data makes it easier to update many rows in one operation. For example, you can create one query that changes the status of all the employees who have worked at the company more than five years, or a set of two queries that first copy and then delete all orders more than two years old. For details, see Modifying Data Using Queries.