Review the FRDATA Database

1. Try This: Review the Data Database

The FRDATA database is open.

 

The FRDATA database has the following:

Ten Tables: Copy of tblMovies 8-8-2012, tblArchivedMovies, tblCustomers, tblGenre, tblMovieRented, tblMovies, tblMovieSearch, tblRating, tblReceipt and tblRentalPrices.


Sixteen Queries: ARchiveMovieMT, ArchiveMovieUQ, CustomerHomePhoneSQ, CustomerNameSQ, DeleteArchiveMovieDQ, Find duplicate for tblMoviesSQ, MovieRentalPriceUQ, MoviesByYearSQ, MovieSearchSQ, MovieSQ, RatingSearchSQ, ReceiptSQ, rptMovieRentedSQ, rptOverdueSQ and rptReceiptSQ.


Eight Forms: Customers, Movies, MoviesRentedSubform, MoviesByRatingChart, MovieSearch, MovieSearchSubform, Receipt and MoviesRentedSubform.

 

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

 

One Macro: OpenSearchMovie

 

We will delete everything BUT the Tables.

All Access Objects