O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting Default Values

When you enter data, you often find that you enter the same value in a field many times. For example, most of your customers might come from the United States, but you have a Country field for those customers outside the United States. Setting a default value for a field saves you the trouble of entering the expected data over and over while still allowing you to edit the value if needed.

Assign a Default Value

  1. Open a table in Design view.

  2. Click the field to which you want to assign the default value.

  3. Type the default value in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required