How to Set Up Inventory Management System With MS Office

By Bonnie Conrad

You can use Microsoft Office as an inventory tracking tool.
i business colleagues preparing for business meeting image by Vladimir Melnik from Fotolia.com

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.

×