Switch to Design View . For the Location Detail field , change the field Size to 30. Enter a description of Room and bin number or alternate location of inventory item , and then save the table . Switch to Datasheet view , apply Best Fit to all of the fields in the table , save the table , and then close the table . Based on your Inventory table , USE the Query Wizard to create a simple query. Add the Item , Storage Location , and Quantity in Stock fields ( in that order) . Keep the Default name of Inventory Query , click Finish to display the query results , and then Close the query . Based on your Inventory table , USE the Form tool to create a form for the table . Save the form as Inventory Form , display the form in Form view , and then close the form . Based on your Inventory table , use the Report tool to create a report . Delete the Category and Frice fields from the report . Save the report as Inventory Report . Sort the Item In field in ascending order . Set the width of the Item In field to 0. 75 inch . Set the width of the Storage Location field to 1 . 5 inches . Delete the page number from the report , Save the report , and then close the report . Close all database objects , close the database , and then exit Access . Submit the database as directed