What is the primary purpose of using a query in MS Access?
- To create a user-friendly interface for entering editing and displaying data in the database.
- 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 visually represent data trends and relationships through charts and graphs.
The correct answer is: D
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.