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.