To locate and retrieve information in a table (or in multiple tables), you create a query. A query is simply a question that you ask a database to help you locate specific information. For example, if you want to know which customers placed orders in the last six months, you can create a query to examine the contents of the Order Date field and to find all the records in which the purchase date is less than six months ago. Access retrieves the data that meets the specifications in your query and displays that data in table format. You can sort that information or retrieve just a subset of its contents with still more specific criteria, so that you can focus on exactly the information you need ”no more or less.
Open and Run a Query
View a Query in Design View