A query asks a question about the information in one or more tables and then retrieves the results.
For example, if you wanted to know which employees had worked for the company for more than five years, you could create a query to examine the contents of the Hire Date field to find all the records in which the hire date is more than five years old. Access would retrieve the information that meets your criteria and display it in a datasheet.
Notice that the query doesn’t look any different than a table. Information is displayed in a datasheet, and you can even edit records in some queries. But, the information in a query isn’t a duplication of the data in a table—it’s just another way of looking at it.