Before You Begin
Before You Begin:
Open the Sample Database
Go to Start -> Microsoft Access 2013.
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.
