Is there a simple way to change all of the values in a field to 0 (zero)?
Is there a simple way to change all of the values in a field to 0 (zero)?
You can create an Update query and run it. You might want to practice on a copy of your DB or make a copy of the table and perform the query on the table copy, first.
If you open the Query Designer, you can drag your table onto the design surface or select it from the Show Table dialog. Add the field you wish to run the UPDATE on to the design grid. In the Ribbon, under the "Design" tab, you can click the Update button. This will provide you with a field that you can type a value into, the Update To field. Type 0 in there and "Run" the query using the Exclamation Point button in the Ribbon.
The heading of your post suggests you may want a new table the same as an existing one but with no data?
If so, in Access 2013, display Table names, select the table, right click, select Copy, right click, select Paste, select Structure Only, name your copy as appropriate, hit Enter.