This article explains how to create a simple query in Microsoft Access. The instructions apply to Access for Microsoft 365, Access 2019, Access 2016, and Access 2013.
How to Create a Simple Select Query in Microsoft Access
Microsoft Access offers a powerful query function with an easy-to-learn interface. It makes it easy to retrieve the information you need from your database.
The goal of this sample tutorial is to create a query that contains the names of all of our company's products, our desired target inventory levels, and the list price for each item. Using the Query Wizard simplifies the process.
If you have not yet installed the Northwind sample database, you should do so before proceeding. Open that database or another database you want to use.
