Using Access, which command will create a new table named NewClients from an existing table named Clients?
A) CREATE NewClients FROM Clients;
B) SELECT * FROM Clients CREATE NewClients;
C) SELECT * INTO NewClients FROM Clients;
D) SELECT * MAKE NewClients FROM Clients;

Question

Quizplus · Accepted Answer

The correct command to create a new table named NewClients from an existing table named Clients is "SELECT * INTO NewClients FROM Clients". This creates a new table with the same structure as the original table and copies all the data from the original table into the new table. Option A is incorrect because the CREATE command does not copy data. Option B is incorrect because the SELECT command cannot be used to create a new table. Option D is incorrect because there is no MAKE command in Access.

Using Access, Which Command Will Create a New Table Named