What must you do after naming a new table 'Tuition2016' in a make table query?

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

After naming a new table 'Tuition2016' in a make table query, the essential step is to execute the query by clicking 'Run'. This action is necessary because the make table query itself does not create the table until it is run. Clicking 'Run' initiates the process of creating the new table based on the specified criteria in the query.

Following the execution, if the query is set up properly, Access will generate the new table with the given name and populate it with data according to the query conditions. This is a key aspect of using make table queries effectively, as it takes completion of this step to transition from a setup phase (where the table is defined) to an execution phase (where the table becomes a reality in the database).

The other options, while they may be appropriate steps in different contexts, do not ensure that the table has actually been created as a result of running the query. For example, saving changes or closing the design window does not impact the execution of the query itself. Therefore, clicking 'Run' is the crucial final step needed to fulfill the purpose of the make table query.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy