Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Switch to Design View . For the Location Detail field , change the field Size to 30. Enter a description of Room and bin number
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started