Using delete queries


show more Using delete queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Using delete queries

If you need to delete records in your table according to certain criteria, you can do it using the Delete Action Query. Let's say one of my customers, Zino Lettis, has a few oils backordered. But while they're waiting, they decide to cancel their order. Create a new query by clicking on the Create tab, and then on the Query Design. Add the Orders table and then close the Show Table window. Double-click on the Customer field and then on the OrderStatus field.

Then come up to Query Types, and choose Delete. There is a new row down here for deletion criteria. In the Customer Criteria, type in ZL11722, and under OrderStatus, enter Backordered. When you click the View button, you'll see three orders ready to delete. Toggle it back and click on the Run button. "You are about to delete three rows from the specified table.

Once you click Yes, you can't use the Undo command reverse the changes. Are you sure?" Yes. We are. Now the orders have been canceled. Go back to the Cu...

Using delete queries
Video duration: 1m 31s 3h 30m Beginner

Viewers:

Using delete queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...