DISCOVER
×

How to Use Microsoft Access for Warehouse Inventory

Updated February 21, 2017

Microsoft Access is one of the most popular and widely used database programs. Access can accomplish many different tasks, from creating a simple product list to producing a detailed inventory for a factory or warehouse.

Log in to your computer and open Microsoft Access.

Download an inventory template. Microsoft offers numerous Access templates for free (see Resources). Browse the templates and choose the one that fits your needs.

Go to the "Forms" section of the database template and look for a data entry form. Double-click on that form to open it, then enter the data for your inventory, according to your chosen form's outline. Continue entering new data until all items have been entered.

Save the inventory database template to your network share. Let any users who need to update the database know where it is located. Give the inventory database a descriptive name, like "Warehouse Inventory."

Things You'll Need

  • Inventory template
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Based in Pennsylvania, Bonnie Conrad has been working as a professional freelance writer since 2003. Her work can be seen on Credit Factor, Constant Content and a number of other websites. Conrad also works full-time as a computer technician and loves to write about a number of technician topics. She studied computer technology and business administration at Harrisburg Area Community College.