Specifying Required Fields and Default Values

Some fields contain essential information. For example, social security numbers are required for employees in order to process payroll and other reports . You set fields like these as required fields , which means that Access refuses to accept a record until you enter an acceptable value for that field. You can also set a default value for a field, a value Access uses unless a user enters a different one. If a field usually has the same value, such as a city or state if most contacts are local, you could assign that value as the default in order to speed up data entry.

Create a Required Field

graphics/1_icon.jpg

Display the table in Design view, and then click a field that you want to be a required field.

graphics/2_icon.jpg

Click the Required box.

graphics/3_icon.jpg

Click the list arrow, and then click Yes.

graphics/04inf14.jpg

Specify a Default Value

graphics/1_icon.jpg

Display the table in Design view, and then click a field for which you want to set a default value.

graphics/2_icon.jpg

Click the Default Value box.

graphics/3_icon.jpg

Enter the default value for the field in the box.

graphics/04inf15.jpg



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net