John wants to create a temporary table using only some fields from the Contacts table for contacts who live in Chicago. What type of query should he create?
A) Parameter
B) Make-Table
C) Append
D) Update

Question

Quizplus · Accepted Answer

John should create a Make-Table query to create a temporary table with only the desired fields for contacts who live in Chicago. This will allow him to easily manipulate and work with the selected data without affecting the original Contacts table.

John Wants to Create a Temporary Table Using Only Some