2 Using Vendor ID as the common field , create a
6 one-to-many relationship between the Vendors table and the Biology Lab Supplies table . Enforce referential integrity and enable both cascade options .
3 Create a relationship report with normal margins , saving 6 it with the default name . Close all open objects .
4 In the last record of the Vendors table , change the data
3 in the Vendor ID field from V-100 to V-001 , and then close the table . ( The related records in the Biology Lab Supplies table will automatically update .)
5 In the Sorted Supplies table , sort the records first in
5 descending order by the Price Per Item field and then in ascending order by the Category field . Close the table , saving the changes to the table .
6 Create a query in Query Design view based on the
15
Biology Lab Supplies table . Add the following fields to the design grid in the order given : Item ID , Item Name ,