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
Int4.accdb database has:
Four
Tables: tblCustomers, tblMovies, tblMovieSearch and tblRating.
Five Queries: CustomerHomePhoneSQ,
CustomerNameSQ, MoviesByYearSQ, MovieSQ, and MovieSearchSQ.
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.