Hi,
Do you mean you wish to add the new fields using SQL as opposed to
opening the table in design view?
You can use the Alter Table statement but you can't do it from the query design grid.
You must choose the SQL view.

Here's an example of adding your date of birth field:

ALTER TABLE Table1 ADD COLUMN DOB DATETIME;

Not sure what data type you want the social security to be.

Also, there is no need to add these fields to another related table.
If your tables are linked by IDs, just use a query to see results from both tables.

--
HTH
Dan Artuso, Access MVP


"david" wrote in message ...
Hi,
Starting out with a table (Table1) how may I, using design grid preferably:
(i) add several new fields to Table1 ?
(ii) add the same fields in a new table (Table2) whose records corresponds
to the existing table via IDs?
[Think of Table1 as having people's name, and new fields to be added are
social security and date of birth. ]
Thanks.
David