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

Queries in Microsoft Access, by default, use an inner join when more than one table is selected, showing only rows with matching values in all tables.

Which of the Following Statements Is TRUE About Queries in Microsoft