Know Your Data
Try This: Review the Database
Open
the Navigation Pane.
Go to
All Access Objects.
The Front Row View has the following:
EIght
Tables: tblCustomers, tblGenre, tblMovieRented, tblMovies,
tblMovieSearch, tblRating, tblRecipt 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