TeacherWeb

Ms Neglia



Top Divider

 

Movie Database

Create a Movie Database.

  1. Go to http://www.washingtonpost.com/wp-srv/style/movies/features/afi100list.htm (if link doesn't work find another list) and copy the list of Top 100 Movies. Paste into EXCEL. You should get 4 columns. Save as Top100.xls.
  2. Go to Access and create a blank database named Top100.mdb. IMPORT the data from the excel file into an Access table. Fix it up so it looks nice and minimizes storage.
  3. Create a corresponding FORM.
  4. Create a corresponding REPORT.
  5. Create 2 QUERIES. One will put the movies in order by Director, the other will show only the movies of ONE director, who directed more than one movie. Name appropriately.

Bottom Divider

TeacherWeb
©2012 TeacherWeb, Inc.