$2$

Open the Cap$1$ Inventory table in Design View. Rename the ID field to Item ID and change the Data Type to Short Text. Continue adding the following fields as Short Text except for Cost, which should have a Currency Data Type:

Item Name

Cost

Category

Sport

Supplier ID

$3$

$4$

$5$

$6$

$6$

$7$ On the Navigation Pane, group the objects by Tables and Related Views.