A query in MS Access is a saved request that lets you ask questions of your data, such as “show all customers in London” or “list unpaid invoices this month,” and then returns only the matching records.

Quick Scoop: What is a Query in MS Access?

In simple terms, a query is how you extract specific information from one or more tables in an Access database.

Instead of scrolling through thousands of rows, you define conditions (criteria), and the query shows only the records you want.

Think of it like this: tables store all your raw data, but queries act like smart filters and calculators that turn that data into meaningful answers.

What Can a Query Do?

Common things queries are used for in MS Access include:

  • Selecting only certain rows (for example, “customers in New York”).
  • Showing only specific columns/fields (for example, “CustomerName” and “City” only).
  • Combining data from multiple related tables (for example, Customer + Orders).
  • Performing calculations (totals, averages, counts, etc.).
  • Supplying data for forms and reports.
  • Changing data in bulk (update, delete, append).

An everyday example: you might have a big Customers table and want just “all customers whose city is London.” A query does that instantly instead of you searching manually.

Main Types of Queries in MS Access

MS Access supports several query types, each with a specific purpose.

[7][5] [5][7] [2][7] [7] [7]
Query Type What it Does
Select query Retrieves and displays data that matches your criteria; can also calculate totals and other expressions.
Action queries Change data: add, update, or delete records in bulk (Append, Update, Delete, Make-table).
Parameter query Prompts the user for a value when the query runs (for example, ask for a city name).
Crosstab query Summarizes data in a pivot-table style layout, showing totals by two dimensions (such as product by month).
SQL query Lets you write the SQL statement directly for more control and complex logic.
Underlying all of these is the idea that a query is a question you ask your database, and the result set (the datasheet view) is the answer.

How Queries Fit Into a Real Database

In a well-designed Access database, information is split across several related tables, like Customers, Orders, and Products.

You then use queries to bring together just the fields you need from those tables, without duplicating data.

For example:

  • Table 1: Customers (CustomerID, Name, Address)
  • Table 2: Orders (OrderID, CustomerID, OrderDate, Amount)

A query can show “Customer Name, Address, OrderDate, Amount” in a single view by joining the two tables through CustomerID.

Quick Forum-Style Take

In MS Access, a “query” is basically a smart question you ask your tables.
You define what fields you want, what conditions to filter by, and Access returns only those matching rows.
It can just show data (select query) or actually change it (action query).

At a high level, if you remember one phrase, remember this:
A query in MS Access is a saved request that retrieves or manipulates data based on conditions you define, turning raw table data into useful information.

Meta description (SEO):
A query in MS Access is a request to retrieve or modify data from tables using specific criteria, helping you filter, calculate, and combine information efficiently in your database.

Information gathered from public forums or data available on the internet and portrayed here.