Run the Delete Query

So the Select Query works. Now, you can change it into a Delete Query.

 

Before You Begin: Change the View

Go to Home ->Views->View.

Select a View: Design View.

 

2. Try it: Create a Delete Query

Go to Query Tools ->Design->Query Type.

Select a Query Type: Delete.

 

Try This, Too: Run the Delete Query

Go to Query Tools ->Design->Results-> Run.

 

What Do You See?  You will be prompted that you are about to delete 73 Rows. You are also reminded that there is no UNDO. This is permanent data heaven.

 

Click Yes to delete the data from the Copy of tblMovies 8-8-2012 Table.

 

So, let's go see what's left in this Table.

Query Tools ->Design->Query Type->Delete

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Delete Quer

1