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
Int7.accdb
database has:
Five Tables: tblCustomers,
tblGenre, tblMovies, tblMovieSearch and tblRating.
Six Queries: CustomerHomePhoneSQ, CustomerNameSQ, MoviesByYearSQ,
MovieSQ,, MovieSearchSQ and RatingSearchSQ.
Four Forms: Customers, Movies, MovieSearch and MovieSearchSubform.
Two Reports: Movies by
Year, Customer Name.
Keep going...
Memo to Self:
Click Enable Content if you
see the Security Warning.