How to Define a Field Default Value in Access 2003

Default values are helpful if you're working in a field in which most or all of the data carries the same value. These steps will show you how to define a field default value in Access 2003.

Things You'll Need

• Microsoft Access 2003

Instructions

1. Open an Access 2003 table in "Design View."

2. At the top of the window, click the field you've targeted for a new default value.

3. At the bottom of the window, click on the "Default Value" box.

4. Type in the value you want to set as the default.

5. Click "Save" to set the default value.

Tips & Warnings

• Resetting a default value once you already have set data into a field will only affect data entered after the default is changed.