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
Made with FlippingBook - professional solution for displaying marketing and sales documents online