What is the primary purpose of using a query in MS Access?

MS Access provides several different objects, each with a distinct job. A form gives a user-friendly interface for entering, editing, and viewing data; a table defines the overall structure of the data and the relationships between different tables; and a report visually presents data trends through charts and summaries. None of these three is built specifically to search through existing data based on conditions the user sets.

A query is used to retrieve specific data from one or more tables based on criteria the user defines, such as showing only students who scored above a certain mark, or combining data from two related tables into one result. This lets a user filter records down to only the relevant ones and sort them in a chosen order, without altering the underlying tables themselves.

The exam distinction is between structure (tables), input and display (forms), presentation (reports), and retrieval based on conditions (queries); only a query is designed to pull out a targeted subset of data on demand.