What is the primary purpose of using a query in MS Access?
- To visually represent data trends and relationships through charts and graphs.
- To define the overall structure of the tables and their relationships within the database.
-
To retrieve specific data from one or more tables based on defined criteria, allowing for filtering and sorting of
information.
- To create a user-friendly interface for entering editing and displaying data in the database.
The correct answer is: C
Explanation
Queries are a powerful tool in MS Access for retrieving specific data from your tables. You can define criteria to filter the data based on specific conditions, allowing you to focus on relevant information for analysis or reporting.