Access Query Lab [ Initials: __________

Print Name _____________________

Signature ______________________

Access Query Lab
Individual Assignment
15 Points

Set Netscape Margins [ Left = 1.0; Right = .2; Top = .5; Bottom = .5; Select Document Title, Page Number, Page Total, & Black Text ]

1] Copy folder N:\thicks\Databases\QueryVideoApp, from the class directory, to floppy drive A.

QueryVideoApp.mdb QueryVideoApp.zip

2] Open database A:\QueryVideoApp\QueryVideoApp.mdb with Microsoft Access.

3] SQL is an acronym for _________________________________________________________

4] Create a Query, called MoviesQuery, that will display all of the information about all movies. In the space below, write the SQL for the this query.

____________________________________________________________________________

5] Create a Query, called MovieRatings, that will display the Title and Rating of all movies. In the space below, write the SQL for the this query.

____________________________________________________________________________

____________________________________________________________________________
6] Create a Query, called RatingR, that will display the Title, Rating, and Category of all movies with an R rating. In the space below, write the SQL for the this query.

____________________________________________________________________________

____________________________________________________________________________
7] Create a Query, called PG, that will display Title, Rating, and Category about all movies whose rating starts with PG. In the space below, write the SQL for the this query.

____________________________________________________________________________

8] Create a Query, called Comedy, that will display Title, Mystery, Drama, Action, SciFi, Comedy, about all comedies. In the space below, write the SQL for the this query.

____________________________________________________________________________

____________________________________________________________________________
9] Create a Query, called DramaOrAction, that will display Title, Mystery, Drama, Action, SciFi, Comedy, about all action or drama. In the space below, write the SQL for the this query.

____________________________________________________________________________

10] Create a Query, called DramaAndAction, that will display Title, Mystery, Drama, Action, SciFi, Comedy, about all action and drama. In the space below, write the SQL for the this query.

____________________________________________________________________________

____________________________________________________________________________
11] Create a Query, called Date 3-2-99, that will display Transaction No and Date, about movies checked out on 3/2/99. In the space below, write the SQL for the this query.

____________________________________________________________________________

12] Create a Query, called DramaDates, that will display Title, Drama, Date, about drama checked out on 3/2/99. In the space below, write the SQL for the this query. Relationship!

____________________________________________________________________________

13] Copy folder A:\QueryVideoApp to your computer science account.

14] Copy folder A:\QueryVideoAppto at least one other floppy disk.

15] Those Labs labeled "Individual Assignment" are to be done separately by each individual. Using a pen, each individual is to print print his/her name at the top of this document in the space provided and sign it. Those Labs labeled "Team Assignment" may be done as a team or individually. Using a pen, each individual on the team is to print print his/her name at the top of this document in the space provided and sign it. Submit only one copy of team assignments!

16] Make sure that all printouts/listings have a 1" left margin!

Include the following in your wire-band binder:

A] Divider

B] Copy of this assignment sheet. Print name and sign!

C] A copy the disk containing folder/directoryA:\QueryVideoApp