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

Question

Quizplus · Accepted Answer

By default, when more than one table is selected in a query, Access performs an inner join, showing only rows with matching values in all tables.

Which of the Following Statements Is True About Queries in Microsoft