Access changes the select query to a delete query, hides the Show row in the lower section of the design grid, and adds the Delete row. Verify that the query returns the records that you want to delete.Ĭlick Design View and on the Design tab, click Delete. For example, you might add the Customer ID of the customer that went out of business and the date after which that customer's orders are invalid.Ĭlear the Show check box for each criteria field. You can also add criteria in the Criteria row. To find just those records, you can add the Customer ID and Order Date fields to the design grid. For example, suppose a customer goes out of business and you need to delete all pending orders for that customer. Create and run a delete queryĬlick the Create tab > Query Design and double-click the table from which you want to delete records.ĭouble-click the asterisk ( *) to add all of the table fields to the query designer.Īdd the fields that you will use to identify the records for deletion. Assign the name of the original version to the backup copy, and open it in Access.

Note: To restore from a backup, close and rename the original file so that the backup copy can use the name of the original version.

Delete duplicates in outlook 2011