graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Create Delete Queries

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 4-16-2014, Table.

 

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

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

1