Know Your Data
Try This: Review the Database
Open
the Navigation Pane.
Go to
All Access Objects.
The Front Row Video database has the following:
Eight
Tables: tblCustomers, tblGenre, tblMovieRented, tblMovies,
tblMovieSearch, tblRating, tblRecipt and tblRentalPrices.
Twelve Queries: CustomerHomePhoneSQ, CustomerNameSQ,
MovieRentalPriceUQ, MoviesByYearSQ,
MovieSearchSQ, MovieSQ, RatingSearchSQ, ReceiptSQ, rptMovieRentedSQ,
rptOverdueSQ rptReceiptSQ and tblMovies_Crosstab.
Eight Forms: Customers, MovieRentedSubform, Movies, MoviesbyRatingChart, MovieSearch, MovieSearchSubform,
Receipt and Switchboard.
Six
Reports: Customer Name. Movies by Genre, Movies by Year,
rptMovieRented-POS, rptOverdue, and rptReceipt-POS.
One
Macro: OpenSearchMovie