Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.3 Navigate Through a Database: View All Access Objects

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