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.

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