Question

what happens to the data of a query ,if the contents of the table associated with it is changed in ms access​

Answer 1

Explanation:

An append query is used to update or change data automatically based on criteria that you specify. Action queries include update, append, make table, and delete.

Answer 2

Answer:

The information in this article explains how to create and run a make table query in Access. You use a make table query when you need to copy the data in a table, archive data, or perhaps save query results as a table.

If you need to change or update part of the data in an existing set of records, such as one or more fields, you can use an update query. For more information about update queries, see the article Create and run an update query.

If you need to add records (rows) to an existing table, you use an append query. For more information about append queries, see the article Add records to a table by using an append query