Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

Steps

Practice Data

1. Select the field for which you want to set a date/time format. The field is selected. 2. Select the General tab in the Field Properties pane, if necessary. The General tab appears.

Scroll as necessary and click in the Contract Date field Click the General tab, if necessary

3. Select the Format property.

Click in the Format box

A drop-down arrow appears in the Format box.

4. Select the Format list.

Click Format

A list of available formats appears.

5. Select the desired format.

Click Medium Date

The format appears in the Format box.

Save the table and switch to Datasheet view. Scroll as necessary to the Contract Date field; notice its format.

Switch back to Design view.

S ETTING Y ES /N O F ORMATS



Discussion

A Yes/No field is limited to either a positive or a negative response and can be displayed as a text box, a check box, or a combo box. You select the field display on the Lookup page in the Field Properties pane.

If the Yes/No field displays its values in a text box, you can select one of three Yes/No data type formats: True/False , Yes/No , and On/Off . Regardless of the format selected, the positive responses of True , Yes , and On are equivalent, just as the negative responses of False , No , and Off are equivalent. Consequently, if the Yes/No field is set to the True/False format and a user enters Yes , Access automatically converts it to True .

When a Yes/No field displays a check box, a selected check box indicates a positive response and a deselected check box indicates a negative response. The check box is the default setting for a Yes/No field.

OFFICEPRO, Inc.

Page 11