Know Your Database

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.


Eleven Queries: CustomerHomePhoneSQ, CustomerNameSQ, MovieRentalPriceUQ, MoviesByYearSQ, MovieSearchSQ, MovieSQ, RatingSearchSQ, ReceiptSQ, rptMovieRentedSQ, rptOverduSQ and rptReceiptSQ.


Seven Forms: Customers, Movies, MovieSearch, MovieSearchSubform, Receipt and MoviesRentedSubform.

 

Six Reports: Customer Name. Movies by Genre, Movies by Year, rptReceipt-POS, rptOverdue and rptReceipt-POS.

 

One Macro: OpenSearchMovie

All Access Objects