Investigate
Your
Record
Sources
Start with the tables. The Movie Title table lists all of the
movies in the store. These movies are in random order: they were
entered as they were purchased. If we use this table in a query, we
can change the sort order.
Try it: Review the Data
Open the Front Row Video database. Open
tblMovieTitles
Sort the Movies alphabetically
Save your changes
Close the Movie Title Table
Go to the Query tab.