view, change and analyze data in different ways
a source of records for forms and reports
Only A
Both A and B
Answer is Right!
Answer is Wrong!
The correct answer is: Both A and B.
Queries in Access can be used to view, change, and analyze data in different ways. They can also be used as a source of records for forms and reports.
Here are some examples of how queries can be used:
- To view a specific subset of data from a table. For example, you could create a query to view all of the customers in a certain state.
- To change data in a table. For example, you could create a query to update the price of all of the products in a certain category.
- To analyze data. For example, you could create a query to calculate the total sales for a certain period of time.
- To create a form or report. For example, you could create a form that displays the results of a query.
Queries are a powerful tool that can be used to do a variety of things with data in Access.