Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties



Step-by-Step

Set a default value.

If necessary, open the Customers table in Design view.

Steps

Practice Data

1. Select the field for which you want to set a default value. The field is selected. 2. Select the General tab in the Field Properties pane. The General tab appears. 3. Select the Default Value property. The insertion point appears in the Default Value box, and the Build button appears.

Scroll as necessary and click in the Catalog Sent field

Click the General tab

Click in the Default Value box

4. Type the desired default value.

Type yes

The text appears in the Default Value box.

5. Press [Enter] .

Press [Enter]

The default value is saved.

Save the table and switch to Datasheet view. Scroll to display the Catalog Sent column in the new record row; notice that the Catalog Sent field for the new record is checked.

Then, switch back to Design view.

S ETTING V ALIDATION R ULES



Discussion

Databases can contain incorrect information due to data entry errors. One method of controlling the accuracy of data is to impose restrictions on the values entered into a field.

OFFICEPRO, Inc.

Page 15