Know Your Data
Try This: Review the Database
Open the
Navigation Pane.
Go to
All Access Objects.
The Front
Row View has the following:
Six Tables: tblCustomers,
tblGenre, tblMovies, tblMovieSearch, tblRating and tblRentalPrices.
Seven Queries: CustomerHomePhoneSQ, CustomerNameSQ,
MovieRentalPriceUQ, MoviesByYearSQ,
MovieSearchSQ, MovieSQ and RatingSearchSQ.
Five Forms: Customers, Movies, MovieSearch, MovieSearchSubform and
the Switchboard.
Three Reports: Customer Name.
Movies by Genre, and Movies by Year.
One Macro: OpenSearchMovie