Use Access to construct a database for a college bookstore store based on the step-by-step instructions listed below.
Create a database and one table:
The name of the database will be Inventory_YourLastname.
Create a table named PRODUCTS based on data in Table 1.
Determine the appropriate data type for each field.
Assign an AutoNumber field to serve as the Primary Key. This should be the first field of the table and named PRODUCTID.
Populate the table with data from Table 1.
Determine the common attribute between the PRODUCTS and SUPPLIERS tables.
Use the common field and create a relationship.