Share via

Inventory Management System in Access

Anonymous
2025-02-13T06:54:37+00:00

Hello Community, I have multiple question and inquiries regarding Microsoft Access. For a brief background check, I have a Digital Design project to complete (IB MYP 5 Curriculum), where I have to find a client and offer any type of solution or product that requires programming. Thus, I decided to do an inventory management database for my Mum who has an online business. For one portion of the project, we are required to assess 3 actual products and highlight their positive and negative aspects.

First of all, I have no access to any databases currently so I don't have any hands on experience with the product, so I don't know where to start. Can you give me a main brief explanation of what the positive aspects and negatives aspects of an inventory management system database in Access. It could include any aspect such as the layout or aesthetics, its difficulty to utilise, the language stacks used (Eg: If SQL or Macros were used properly), its functionality, fields and table relationships.

Additionally, can you recommend me where I can find databases online to analyse them and research them ?

Thank You for your support.

Microsoft 365 and Office | Access | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,765 Reputation points Volunteer Moderator
    2025-02-13T13:00:18+00:00

    There are two versions of the Northwind Template, one for beginners, one for developers.

    Inventory is more fully handled in the developer version, so I recommend that you choose it.

    BTW. You are also asking for help with completing an assignment in a course you are taking. I would urge you to think about that differently.

    If you allow someone else to give you the results needed to get a grade in a course, you have short-changed yourself. By not digging out the information and learning it, you are giving up the chance to, well, learn it. Invest in yourself by studying and reading and trying out the things you need to know to complete the assignment.

    Most of us already have some level of experience, so reiterating all of that knowledge for you does none of us any good either.

    0 comments
  2. Anonymous
    2025-02-13T12:49:20+00:00

    Hi Jad,

    Here's a brief introduction followed by the summary:

    Microsoft Access is a popular choice for small to medium-sized inventory management systems due to its ease of use and powerful features. However, it also has some limitations. Below are the key advantages and disadvantages of using Access for inventory management:

    Advantages:

    1. User-Friendly: Easy to set up and use, even for beginners.
    2. Customizable: Can be tailored to specific needs with forms and queries.
    3. Integrated: Works seamlessly with other Microsoft Office tools.
    4. Powerful Features: Supports VBA for advanced customization.

    Disadvantages:

    1. Scalability: Not suitable for very large datasets or high user volumes.
    2. Security: Limited security features compared to enterprise databases.
    3. Complexity: Managing large systems can be challenging.
    4. Compatibility: Potential issues when shared across different versions of Office.

    Where to Find Sample Databases:

    You can find online templates by navigating to Microsoft Access > New > Business > Inventory.

    0 comments
  3. ScottGem 68,810 Reputation points Volunteer Moderator
    2025-02-13T12:39:59+00:00

    I suggest you search for the Northwinds Sample Database. It is an Order entry systems that includes an Inventory mgmt piece. It would be a good tool for you to learn from.

    0 comments