Copying a data value to all records

Dear Kevin

Thank you for attending Access Introduction!! I hope you enjoyed the course and benefited from it.


In teh Table design view click the field where you want the default value

On the Filed Prperties section type in the value you want every new record to have in the Default Value box.

If you go to the Datasheet view and create a new record ytou will notice the field will automatically have the data that you entered in the design view.

If you create a form based on this table the default value will be copied over.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007