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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.