Making Business Decisions II

You have sucessfully created the tables, fields, constraints and relationships from MBD II in the Creating Tables and Relationships section. In addition, you have entered the needed information provided in from the MBD II Tables section to test your relationships. You now need to create some queries that will help you analyze your data better, as well as use this information for creating reports later on. 

PROJECT FOCUS:

  • Create a query that lists all the customers who order the product "Vienna". Include the customers name (first and last), the date they ordered the product, and the price. Sort the list by customer last name.
  • Create a query that lists all the customers who order the product "English Breakfast" between October 5, 2008 and October 10, 2008. Include the customers name (first and last), date, quantity and price. Sort the list in order of date, then customer last name.
  • Create a query that lists all the customers who live in Littleton and placed an order for "Chocolate Hazelnut". Include the customers name (first and last), address, and the date. Sort the list by customer last name.
  • Create a query that lists all the products that customers have not bought. Include the product name and price.

2007-2009. All Rights Reserved
BETA VERSION