Can you set a "Default Value" for a record in a table using a query?

We may be thinking about two different things.

In Access, a "default" value in a table is the value which will be added WHEN A NEW RECORD IS ADDED, provided no other value is entered for that field (in other words, use "X" as a default value). If this is what you are after, open the table in design view, select the field, and set the default value.

It sounds like you might be looking for a way to SET values in records that already exist. If this is what you need, create an UPDATE query (see Access HELP for details).

Good luck!

If I may help this article is good to read. The above advise also was very good.
http://office.microsoft.com/en-in/access-h...A010096451.aspx