Start -> All Programs ->Microsoft Office->Microsoft Office Access 2010

Before You Begin

Before You Begin: Open the Sample Database
Go to Start -> All Programs ->Microsoft Office.
Click on Microsoft Office Access 2010.
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.