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.