How to Use Microsoft Access for Warehouse Inventory

Written by bonnie conrad
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Microsoft Access for Warehouse Inventory
Use a database to track your inventory. (computers network image by Orlando Florin Rosu from Fotolia.com)

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.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Inventory template

Show MoreHide

Instructions

  1. 1

    Log in to your computer and open Microsoft Access.

  2. 2

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

  3. 3

    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.

  4. 4

    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."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.