Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

Save the table and switch to Datasheet view. Notice that all entries in the Shipping Method field now display the text values. Select the next record in which the Shipping Method field is blank and select Emery from the lookup list. Press [Down] , type the letter u , and press [Down] again. Notice that Access completes the entry.

Type Post Office , and press [Down] ; a Microsoft Office Access message box informs you that the text entered is not on the list. Select OK and press [Esc] twice.

Although text values appear in the field, the data actually stored in it are the numeric values in the bound column. Right-click any field in the Shipping Method column, select Text Filters , then select Equals... , type UPS , and press [Enter] . Notice that no records are found; even though UPS appears in several fields in the datasheet, it is not the actual data stored in the field. Click the Toggle Filter button on the Home tab to display all records.

Now right-click any field in the Shipping Method column, select Text Filters , then select Equals... , type 1 , and press [Enter] . The filter now works, because you filtered for data actually stored in the field. Click the Toggle Filter button to display all records.

Save the Orders table and close it. Close FIELDS1.ACCDB .

Page 32

OFFICEPRO, Inc.