Which of the following statements is true about queries in Access?
A)Queries can include fields from only one table.
B)Only rows with value matches in all tables are shown by default if more than one table is selected.
C)The Query Design option is present in the DATABASE TOOLS tab.
D)Only rows having "Number" Data Type can be used to arrange the results of a query in ascending order.

Question

Quizplus · Accepted Answer

By default, Access uses INNER JOINs in queries, which only show rows with matching values in all selected tables.

Which of the Following Statements Is True About Queries in Access