ࡱ> egd5@ W*bjbj22 "`XXW"++++<N+/(+,,,,,,,v/x/x/x/x/x/x/$1Rq3/,,,,,/,,/,,,, ,,v/,,v/,,-:-,.,+ |1 +, . B.4/0/. 74$,d74.74.$,,,,,,,,//D)+, +VIDEO DATABASE ASSIGNMENT Before you begin, use the attached sheets to obtain information for your database. Look up your favorite (or even not so favorite) movies at  HYPERLINK "http://www.amazon.com/" http://www.amazon.com/ and find a good assortment of videos (click Videos on the left to get the appropriate page). These must be movies you have seen. Include movies from your childhood, such as Wizard of Oz, as well. Create a new database in Access and name it: Movies N Stuff by Your Name. Create a table first using Design View. For the fields use: Movie, Star, Rating, Category, and Year Use an appropriate Data Type for each (For example, text for Movie name, Lookup Wizard for Rating, number for the Year) Use the Lookup Wizard to create your own Lookup Lists for Category and Rating. Be sure to type in the words exactly as they are shown on your sheet so you can run queries without any problems. You will have 5 ratings and 8 different categories (see attached sheet). Save the table as: Movies by Your Name Create an entry form using the Form Wizard for entering in movies to the database. Make it nice. Use the justified layout. Name the Query FormMovies N Stuff Entry Form by Your First Name. Raise your hand so I can check your form and table to make sure they are created properly before going on. Lookup lists must work. Teacher initials:_____ Begin entering the data using the entry form. Be sure to type in everything as shown on the handout and spell all names and titles correctly. Any misspellings can cause problems for running queries. Run a query that gives only the Movie Title, Rating, and Date. Include only the movies that came out in 2002. (HINT: Use the Simple Query Wizard to select fields, modify the design, set criteria for date as 2002). Save the Query as 2002 Movies by Your Name. Print the query. Run a query that gives only the Movie Title, Star, Rating, and Category. Include only Horror movies that are Rated R. Save the Query as R Rated Horror Movies by Your Name. Print the query. Save and exit the database. VIDEO DATABASE: MOVIES N STUFF (PAGE 1) MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  VIDEO DATABASE: MOVIES N STUFF (PAGE 2) MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________  MOVIE:_________________________ STAR:__________________________ RATING: G PG PG-13 R NR CATEGORY: ( Classic ( Comedy ( Family ( Drama ( Musical and the Arts ( Foreign ( Horror ( Special Interest YEAR:__________________________     $ D K : j 3 !%*-.Y,-7 jhW4CJOJQJhW4CJOJQJhW4CJOJQJhW4OJQJhiOJQJhL=>*OJQJh*hL=0JOJQJ#jh*hL=OJQJUhL=hL=OJQJjhL=OJQJUhL=OJQJhL=4 5 ] ^  k l 56M & F^`^ & Fh^hh^hgdL= & F^`$a$W*MN+,-XYZz{#JKklm$If$a$h^h & F^`78K()?@JK^~  "#;<RS]^q *+67OPfgqr&'23=>IJbcyz,-.hW4OJQJhW4CJOJQJhW4CJOJQJ jhW4CJOJQJU 6]^~Ipq$If2]yyyyyyyyyyyyy$Ifkd$$IflF D*XXX0    4 laEp"#X$If.9:EFPQ\]uv@ABMNYZdepqSTU`almwxfghstz{|hW4OJQJhW4CJOJQJ jhW4CJOJQJhW4CJOJQJU67lyyyyyyyyyyyyy$Ifkd]$$IflF D*XXX0    4 la#IJ6\]$If()Jpqyyyyyyyyyyyyy$Ifkd$$IflF D*XXX0    4 la ,-  ?n*+ABLM` $%=>TU_`shW4OJQJhW4CJOJQJhW4CJOJQJ jhW4CJOJQJU;<]  ,-.NOp?@$If@ABmno 8_}x}rrrrrrrrr$If$a$kdu$$IflF D*XXX0    4 la _` Krs3 ^ $If    ! + , 7 8 P Q g h r s !!!(!)!4!5!?!@!K!L!d!e!{!|!!!!!!."/"0";"<"G"H"R"S"^"_"w"x""""""""A#B#C#N#O#Z#[#e#f#q#r##########U$V$W$b$ jhW4CJOJQJhW4CJOJQJhW4CJOJQJhW4OJQJU !!G!r!!!!!!yyyyyyyyyyyyy$Ifkd$$IflF D*XXX0    4 la!!!!$"%"Z"""""""""#7#8#m######$If###$$%$K$L$$$$$$$$yyyyyyyyyyyyy$Ifkd$$IflF D*XXX0    4 lab$c$n$o$y$z$$$$$$$$$$h%i%j%u%v%%%%%%%%%%%%%%{&|&}&&&&&&&&&&&&&&&&'''''''''''''''''(.(/(((((((((((((())hW4OJQJhW4CJOJQJhW4CJOJQJ jhW4CJOJQJU$%%8%^%_%%%%%&& &)&*&K&q&r&&&&&''$If'''='>'_''''' ((.(/(0(yyyyyyyyyyyyy$Ifkd$$IflF D*XXX0    4 la0(P(Q(r((((( )!)A)B)C)c)d))))) *3*4*T*U*$If) ))!)A)B))))))))))))))** *!*4*T*W*hW4OJQJhW4CJOJQJ jhW4CJOJQJhW4CJOJQJU*V*W*}kd$$IflF D*XXX0    4 la &P/ =!"#$%DyK http://www.amazon.com/yK .http://www.amazon.com/$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4$$If!vh5X5X5X#vX:V l05X4<@< NormalCJ_HmH sH tH P`P L= Heading 1$<@&5CJKHOJQJDA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List 6U@6 L= Hyperlink >*B*phW"`5]^ kl56MN+,-XYZz{# J K k l m 6 ] ^ ~   I p q 2 ]   E p "#X67l#IJ6\]()Jpq;<]  ,-.NOp?@ABmno 8_` Krs3^Gr$%Z78m%KL8^_ )*Kqr=>_  . / 0 P Q r !!!A!B!C!c!d!!!!! "3"4"T"U"V"Y"00 00p 0p0 000 00 00 00 00 00 00 00 00 0000M90M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 aM90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M90  M90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M90  M90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M90 M90  xTxpxxxM900M90M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90  *+M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 |M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M90M90M90M90M90M90M90M90M90M90M90M90 M907.b$)W*"&*.M@_ !#$'0(U*W* !#$%'()+,-/W*W"XY"Y"3:j !%V"Y"Y"Oran R-3 School DistrictOran R-3 School District Tonya SkinnerA2\ h^h`OJQJo( h^h`OJQJo(2\AiL=W4-XYl  -@Amn/ B!U"V"Y"+? @**!x**W"@UnknownG:Times New Roman5Symbol3& :Arial5& :Tahoma;Wingdings"h4t4t 7> 7>!24F"F"3QH(?L=)VIDEO DATABASE: MOVIES  N STUFF (PAGE 1)Oran R-3 School District Tonya Skinner   Oh+'0 (4 P \ ht|*VIDEO DATABASE: MOVIES N STUFF (PAGE 1)WoIDEOran R-3 School DistrictN SranNormal3Tonya Skinnerl 2nyMicrosoft Word 10.0@F#@@1 @@1  7 ՜.+,D՜.+,T hp|   />F"A *VIDEO DATABASE: MOVIES N STUFF (PAGE 1) Title 8@ _PID_HLINKSAh'*http://www.amazon.com/  !"#$%&'()*+,-./02345678:;<=>?@ABCDEFGHIJKLMNOPQRSUVWXYZ[]^_`abcfRoot Entry F1 hData 11Table9K4WordDocument"`SummaryInformation(TDocumentSummaryInformation8\CompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q