graphic2
graphic1

Start -> Microsoft Access 2013

Before You Begin

Before You Begin: Open the Sample Database
Go to Start -> Microsoft Access 2013.
Access will prompt you to open a database.

You can continue with the same database that you saved or download the sample database if you wish.

The FrontRowVideo Adv2.accdb database has:

Five Tables: tblCustomers, tblGenre, tblMovies, tblMovieSearch and tblRating.

Six Queries: CustomerHomePhoneSQ, CustomerNameSQ, MoviesByYearSQ, MovieSQ, MovieSearchSQ 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.
 

Memo to Self: Click Enable Content if you see the Security Warning.