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.