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. This lesson uses the
database that was programmed in the previous lesson. You can
continue with the same database if you wish.
The
FrontRowVideo Int10.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.
Memo to Self:
Click
Enable Content if you
see the Security Warning.
