Question 1: Download the ValleProducts.accdb database. Save the file as ValleeProducts_LastNameFirstName.accdb
Question 2: Create a new table named Orders using the table design below. You may create your table in design view or datasheet view. Save the Orders table as Orders Your Name #3.
Question 3: Add the three records listed belowto the Orders table.
Question 4: Define a one-to-many relationship between the Customer table and Orders table. Right click in the window and select Show table. Select the referential integrity option and both cascade options for the relationships. Save the relationship.
Question 5: Create a query based on Customer table that shows CustomerNum, CustomerName, Street, City, and State for all customers in Grand Rapids, South Bend, and Toledo. This will be a List-of-Values query.
Save as #5 Cities YourName. Query results will show 8 records.
Question 6: Create a query based on the Coffee Table that displaysall four fields. Show only those records that do not have the following Coffee Types: African, Blended, and Flavored.
Save as #6Coffee Types YourName. The query results willshow 13 records.
Question 7: Create a query based on the Product Table that shows all Decaf products that have a WeightCode field value of A, or whose Price field value is less than 30. Display all fields from the Product table. Open the Product table and look in design view if you need information about how Decaf is listed there. Remember to indicate Decaf in both rows. Hint: Look in design view of the Product table to see how Decaf is displayed. You must be sure to use the OR operator for A or < 30 which means those two criteria must be on two different rows.
Save the query as #7 Decaf YourName. Your results should show 35 records.
Question 8: Create a new query based on the Product table. Use aggregate functions to find the lowest, average and highest values in the Price field. Name the fields: Lowest Price, Average Price and Highest Price, respectively.
Save the query as #8 Prices YourName. Your results will show one row of results: $7.99 $30.36 $234.00
Question 9: Create a new query based on the Product table. Use aggregate functions to find the lowest, average and highest values in the Price field by WeightCode. Name the fields: Lowest Price, Average Price and Highest Price, respectively.