D

V

Rentals

Task 3/1 - Performing a sort on a table
•    Create a query for all DVD Rentals customers and SORT by surname
•     Fully justify why you created this query

Task 3/2 - Performing a sort on more than one field
•    Create a query  to search for all DVD’s and SORT by  Date released, category,
     DVD Name
•     Fully justify why you created this query.


Task 3/3 - Multiple criteria query
•     A customer has asked you to give her a list of all DVD’s that are Comedy
      OR Children’s with a certificate PG, with the Date released is greater than
      01/01/ 2003 AND  01/03/2008.  Sort by Date released.

Task 3/4 - Query using complex criteria on inked tables
•      Create a query to search customer surname, forename,  date DVD hired
       DVD ID and DVD name.

      • Customer ID should be a parameter to find individual customer details
      • Date hired should be for DVD’s hired within the last year

Task 3/4(b) - 2nd Query using complex criteria on linked tables
    The Shop needs a list of DVD’s due back every morning