To create an Insert Values query
Note If more than one table is displayed in the Diagram pane when you start the Insert Values query, the Query Designer displays the Insert Values dialog box to prompt you for the name of the table to update.
Caution The Query Designer cannot check that a value fits within the length of the column you are inserting. If you provide a value that is too long, it might be truncated without warning. For example, if a name column is 20 characters long but you specify an insert value of 25 characters, the last 5 characters might be truncated.
When you execute an Insert Values query, no results are reported in the Results pane. Instead, a message appears indicating how many rows were changed.