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.

Start -> All Programs ->Microsoft Office-> Microsoft Office Access 2010