fill each record with same field entry after records already exist

[Guest]

How would I apply a given value to a newly created field of an existing table
with existing records. The value would be the same for all records.

I understand that for all new records I can simply set the default value in
design view to the desired value but I do not know how to automatically apply
this value to existing records.

 

[Rick Brandt]

How would I apply a given value to a newly created field of an existing table
with existing records. The value would be the same for all records.

I understand that for all new records I can simply set the default value in
design view to the desired value but I do not know how to automatically apply
this value to existing records.

Use an Update query.

UPDATE TableName
SET FieldName = Value