Question

When you instruct Access to execute a query, does it produce a resulting table? Yes or no? Please explain why.

Answer 1

Answer:

Whenever we instruct access to execute the query, below two things will be checked.

1. Compilation or syntax errors in the query (missing keywords, wrong usage of the query) -> If the query is passed then it will check for the data in the tables.
2. Data availability in the Tables. -> Data will be displayed after the query has been executed successfully. If the tables does not contain any values or data then the query will result in an empty table.

The resulting table will be displayed if the query has passed without any issues. It will return with data if the data is available else empty table.

Thanks and all the best. Let me know in case if you have any doubts.