Lesson 5/27/09

1. Query Practice: Using DB AC10, write the following;
a. Display all products of bread where the quanity in stock is greater than 50.
Save as qryproducts.

b. Display all products of bread where the quantiy is less than 50.
Save as qryproductsunder50

c.Display all customer names for customers who live in the city of San Francisco.
Save as qrySanFrancisco

d.Display all customers who live in Mill Valley or Larkspur.
Save as qryMillLarskspur

e. Display all customers names who currently receive a newsletter.
Save as qrynewsletter
2. Report: Create a report totalling the quantity of all bread products. Save the report as rptQuantity.

3. Review and make final corrections to DB.