To convert a query into a 'make table' query, what must you click in the Query Tools Design tab?

Study for the CGS Access Test. Leverage flashcards and multiple choice questions, each with hints and explanations. Be prepared for your exam and excel!

To convert a query into a 'make table' query, selecting the 'Make Table' option in the Query Tools Design tab is essential. This action indicates to the software that the result of the query should not only be displayed but also saved as a new table in the database.

By choosing 'Make Table', you initiate the process of defining the new table's name and specifying how the data from the existing query will be used to populate this new table. This is particularly valuable when you need to store the results of a query in a more permanent form for future use or analysis, preserving the data independent of the original tables.

The other choices do not accomplish this specific task; they serve different functions within the query design context. Selecting 'Design View' would simply allow you to modify the query without converting it, while the 'Create Query' option relates to starting a new query rather than modifying an existing one. 'Run Query', on the other hand, executes the query to display the results but does not change the structure or purpose of the query to create a new table. Thus, choosing 'Make Table' is the correct and necessary step to achieve the stated goal of converting a query into a make table query.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy