Question

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.
A. Select Query
B. Design view
C. Query
D. Query design

Answer 1

Answer:

The answer is "Option D".

Explanation:

Query design is a part of the Microsoft Excel, It is used to constructs the queries that is use for reading, adding, removing, and modifying data into the database.  In this query get the correct set of information that hits hundreds of (inner and outer) junctions, sub queries, and temporary tables, and other options are not correct which will explain as follows:

• In option A and option C is not correct because it is used for design and show data after execution of query.

• In option B, Design view is used for show data, It is used after query design, that's why it is not correct.