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 View has the following:

Six Tables: tblCustomers, tblGenre, tblMovies, tblMovieSearch, tblRating and tblRentalPrices.


Seven Queries: CustomerHomePhoneSQ, CustomerNameSQ, MovieRentalPriceUQ, MoviesByYearSQ, MovieSearchSQ, MovieSQ and RatingSearchSQ.


Five Forms: Customers, Movies, MovieSearch, MovieSearchSubform and the Switchboard.

 

Three Reports: Customer Name. Movies by Genre, and Movies by Year.

 

One Macro: OpenSearchMovie

All Access Objects