In the following exercises, you will use the data in the Premiere Product database. In each case, use QBE to obtain the desired results. Please submit a softcopy of your homework. Please make a copy of the database before you start your homework. We need the database in its original state for later discussion.

1. list the number and name of all customers that are represented by sales rep 65

2. for each order, list the order number, order date, the number of the customer that placed the order, and the name of the customer that placed the order

3. find the total of the balances for all customers represented by sales rep 65

4. list all columns and all records in the Part table. Sort the results by part number within item class

5. create a new table (Please just write a query, do not execute the query) named Appliance to contain the columns PartNum, Description, OnHand, Warehouse, and Price for all rows in which the item class is AP.

6. In the Part table, change the description of part KL62 to Electronic Dryer (Please just write a query, do not execute the query)