Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Image of a person holding a scanner and tablet in front of items on a shelf. Other shelves with items are visible in the back.
Figure 14.1 As businesses grow, they often need to use more advanced features in Microsoft Access for complex database design and querying to help with tasks like managing inventory. (credit: modification of “Man in Black and Gray Plaid Dress Shirt Holding Black Smartphone” by Tiger Lily/Pexels, CC0)

Now it is time to discuss advanced database applications at WorldCorp. As you continue to grow with the company, we will expect you to dive deeper into what is possible with data analysis. Your role will continue to advance as an analyst working with data professionals supporting various teams within WorldCorp.

WorldCorp wants to grow and expand into its independent retail locations to better serve its vast customer base. It still needs to create a database to manage inventory for these new locations. This would involve more complex database design and querying, as well as the use of advanced features in Microsoft Access.

First, we want to determine the data WorldCorp might need to store. We can start by identifying the key elements to track—potential product names, SKU numbers, locations, quantity on hand, and likely reorder points—and designing a table structure to best serve each type of data. For example, you could create a “Products” table with fields for product name, SKU number, description, and unit cost, as well as a “Locations” table with fields for location name and address.

WorldCorp would need a user interface to enter the data for each product and location into their respective tables. We will walk through some advanced steps in Access queries to retrieve specific sets of data from specific tables—for example, a query to find all products with a quantity on hand below the reorder point, or to find all products located in a specific store. You will also learn how to create reports to help keep track of inventory by summarizing and displaying data in a user-friendly format. For example, you could create a report that shows inventory levels by location, or one that shows sales trends by product category.


This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.