$1$

Start Access. Open the downloaded file named Student$\_$Access$\_2$E$\_$Biology$\_$Supplies.accdb, and enable the content.

$2$

Using Vendor ID as the common field, create a one$-$to$-$many relationship between the $2$E Vendors table and the $2$E Biology Lab Supplies table. Enforce referential integrity and enable both cascade options.

$3$

Create a relationship report with normal margins. Save it as $2$E Relationships Close all open objects.

$4$

In the last record of the $2$E Vendors table, change the data in the Vendor ID field from V$-100$ to V$-001,$ save and then close the table. $($The related records in the $2$E Biology Lab Supplies table will automatically update.$)$

$5$

Open your $2$E Biology Lab Supplies table. Sort the records first in Descending order by Price Per Item and then in Ascending order by Category. Close the table, saving changes to the table.

$6$

Create a query in Query Design view based on the $2$E Biology Lab Supplies table to answer the question: What is the item ID$,$ item name, room, location, and quantity in stock for all of the items, sorted in ascending order by the Room field and the Location field? Display the fields in the order listed in the question. Save the query as $2$E Items by Room Query. Close the query.

$7$

Copy the $2$E Items by Room Query to create a new query with the name $2$E Item Categories Query. Redesign the query to answer the question: What is the item ID$,$ item name, category, vendor ID$,$ and quantity in stock for all items, sorted in ascending order by the Category field and the Vendor ID field? Display only the fields necessary to answer the question and in the order listed in the question. Be sure that the fields are sorted in the correct order in Design view, so that the results display the categories in ascending order, then the Vendor IDs within each category in ascending order. Close the query, saving the design changes.

$8$

Copy the $2$E Items by Room Query to create a new query with the name $2$E Supplies Sort Query. Redesign the query to answer the question: What is the item name, category, price per item, and quantity in stock for all supplies, sorted in ascending order by the Category field and then in descending order by the Price Per Item field? Display only the fields necessary to answer the question and in the order listed in the question. Close the query, saving the design changes.