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,