Most databases contain vast amounts of information. A query can extract from a database table exactly the data you need, or it can be used to add new information to the table.
Queries can send their information to tables, forms or reports.
They can draw their information from tables and other queries. It can be used to collect exactly the information you need from other queries or from database tables. Select queries can also be used be used to update database tables. Although it is called a Totals query, it can also be used to find averages, minima, maxima, standard deviations, etc. In many ways, it is similar to the Subtotals tool in Excel, except that only the subtotals are shown.