|
3.
Try it: Review the Data Go to
All Access Objects->Tables. Open a
Table:Copy of tblMovies 8-8-2012. Try
This, Too: Sort the Records Select a
Field: Year. Go to
Home ->Sort & Filter->Ascending. What Do
You See? There were 411 Records in Copy of tblMovies 8-8-2012.
The Delete Query deleted 73 movies, leaving 338. Well, for
what it is worth, the movies were effectively deleted as promised. Close
the Copy of the Movies Table. Do
This, Now" Save the Delete Query Go to
File->Save. Enter a
name: DeleteArchiveMoviesDQ. Close
the Delete Query.
Home ->Sort & Filter->Ascending
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create a
Delete Query |
|
| |
