Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

If necessary, open the Customers table in Design view.

Steps

Practice Data

1. Select the field for which you want to set a yes/no 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 Catalog Sent 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 yes/no format.

Click Yes/No , if necessary

The format appears in the Format box.

6. Select the Lookup tab.

Click the Lookup tab

The Lookup tab appears, with the Display Control box selected.

7. Select the Display Control list.

Click Display Control

A list of available options appears.

8. Select the desired yes/no control. The option appears in the Display Control box.

Click Text Box

Save the table, and switch to Datasheet view. Scroll to the Catalog Sent field; notice the text values. Click in any field with a Yes value; notice that the actual stored value is -1 .

Click in any field with a No value; notice that the actual stored value is 0 . Then, double-click the 0 value, type true , and press the [Down] key. Notice that the true entry changes to a Yes .

Practice the Concept: Switch to Design view and display the Lookup tab. Change the Display Control property of the Catalog Sent field back to Check Box . Then, save the table.

OFFICEPRO, Inc.

Page 13