How to Set Up Inventory Management System With MS Office

by Bonnie Conrad
You can use Microsoft Office as an inventory tracking tool.

You can use Microsoft Office as an inventory tracking tool.

Microsoft Office is an excellent tool for developing all kinds of business applications, including an inventory management database. The database program included in the Microsoft Office suite can be used to develop a comprehensive database management system, including complete information about the various products the company produces.

Log on to your computer and open Microsoft Access. Microsoft Access is the database program within the Office suite, and it is the product best suited to building a comprehensive inventory management system.

Click on the "Tables" section of the blank database and choose "Create table by using wizard." This is the easiest way to create a new table.

Enter each field you need to capture for your inventory management system. Some fields that should be included are part number, product description, cost per unit, selling price and number of units.

Click on the "File" menu and choose "Save," then close your table and click on the "Forms" section of the database.

Choose "Create form by using wizard" and select the table you just created as the input source. Click on the fields you want to include in your data entry form.

Choose from the list of available formats for your data entry form, then click "Finish" to complete the data entry form. Ask your workers to use this data entry form to record changes to the inventory database.

Items you will need

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.

Photo Credits

  • photo_camera business colleagues preparing for business meeting image by Vladimir Melnik from Fotolia.com