Download Article Download Article

Microsoft (MS) Access offers a versatile way to create inventory assessment tools by building a database that will reveal inventory numbers at a glance. Internal resources, such as tutorials, can help users to create databases in Access, but some basic steps still apply. Use these fundamental steps to make an inventory database in Access.

Steps

  1. 1
    Consider the needs of the business.
  2. 2
  3. 3
    Craft your MS Access database.
  4. 4
  5. 5
    Populate the inventory database with information.
  6. 6
    Link the MS Access inventory database to other technology as appropriate. Some advanced database managers use technologies like MySQL or other database tools to structure queries for databases. This may, or may not, apply to your database handling situation.
    Advertisement

Community Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

      Advertisement

      Video
      By using this service, some information may be shared with YouTube.

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Thanks for submitting a tip for review!

      Related wikiHows

      Frame a Questionnaire for Data CollectionFrame a Questionnaire for Data Collection
      Use Microsoft AccessUse Microsoft Access
      Make a Database Using MS AccessMake a Database Using MS Access
      Download Microsoft AccessDownload Microsoft Access
      Link Tables in AccessLink Tables in Access
      Create Action Queries in Microsoft AccessCreate Action Queries in Microsoft Access
      Keep Track of Your CD Collection Using Microsoft AccessKeep Track of Your CD Collection Using Microsoft Access
      Find Duplicates Easily in Microsoft AccessFind Duplicates Easily in Microsoft Access
      Establish User Level Security in Microsoft AccessEstablish User Level Security in Microsoft Access
      Disable Microsoft Security EssentialsDisable Microsoft Security Essentials
      Mail Merge Using a List from Access DatabaseMail Merge Using a List from Access Database
      Open an Access Database in Exclusive Mode in Access 2013Open an Access Database in Exclusive Mode in Access 2013
      Design a Form Filling Database Using Microsoft AccessDesign a Form Filling Database Using Microsoft Access
      Keep and Control Records Using Microsoft AccessKeep and Control Records Using Microsoft Access
      Advertisement

      About This Article

      wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 314,972 times.
      How helpful is this?
      Co-authors: 8
      Updated: March 29, 2019
      Views: 314,972
      Categories: Microsoft Access
      Thanks to all authors for creating a page that has been read 314,972 times.

      Is this article up to date?

      Advertisement