Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

14. Switch to Datasheet view, saving the changes. Tab to the Zip field for the first record row and type 12345 . Notice the input mask. 15. Tab to the Home Phone field, type 1234567890 , and press [Enter] ; notice that the phone number is automatically formatted according to the input mask. Close the Reps table. 16. Open the Project table in Design view. Create a new field below the Trainer Initials field; name it Sales Rep and make it a lookup field. ( Hint: Select Lookup Wizard from the Data Type list.) Select the option to type in the values. Then, type the following values for the lookup column: PJ , RJ , KM , and SH . Finish the Lookup Wizard. 17. Switch to Datasheet view, saving the changes. Add the following values to the Sales Rep column for the first four records:

Project ID

Sales Rep

1 2 3 4

RJ

SH

PJ

KM 18. Switch back to Design view. Add a new sales representative to the Sales Rep value list by typing; "JW" after the last entry in the Row Source box. Then, change the value in the List Rows box to 5 . ( Hint: Use the Lookup tab.) 19. Switch to Datasheet view, saving the changes. Select the first empty Sales Rep field (in the Project ID 5 row) and select JW from the drop-down list.

20. Close the Project table. 21. Close the database file.

Page 34

OFFICEPRO, Inc.