graphic2
graphic1

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

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, tblReceipt 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

All Access Objects