How to create new column in Access - using query ?

Question

How can I create a new column on an existing table in Access using a query?

Answer 1

You add columns to a database using ALTER TABLE.

To add a column:

ALTER TABLE table_name
ADD column_name column-definition;

Eg:

ALTER TABLE supplier
ADD supplier_name  Text(50);

ALTER TABLE supplier
ADD supplier_number  Long;

See here for some more details.