• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Entering a Default Value

After you've opened the table you want to change in Design view, click in the field for which you want to enter a default value (in this example, the StateOrProvince field).

In the property sheet, click in the Default Value field.

Type the default value in quotation marks (in this example, “IN” is entered).

The default value is now included as part of the database table design. Click the Save button on the Standard toolbar in the main Access window to save changes to the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint