Open the tblClient table in Design View. Use the Input Mask Wizard to add an input mask to the Phone field. The input mask should use parentheses as separators for the area code, a space between the area code and the number, and a dash between the second and third groups of numbers, as in (123) 456-7890, with only the last seven digits required. Do not store the literal display characters if you are prompted to do so. Save the tblClient table and switch to Datasheet View. Change the Phone field value for the record with ClientID A10026 to (716) 555-0001 .

File V View Home Create External Data Paste Cut E Copy Views Clipboard All Access Obje... earch.. P Tables tblBilling tblClient Format Painter GradingInfoTable tblEmployee tblLocation = tblTrainer * Filter I Ascending Descending 2 Remove Sort D + A12565 ASCE A12865 + A12465 A12465 tblClient Client ID Client First Client Last + A10026 Alfred Pineda A10235 Randy Gibson Miller A10486 Christopher Locke + A10526 Locke A10945 A10845 A15671 MOEDE B10585 Database Tools B15264 www. + B15678 B18536 wwwwww B19356 + C10256 + C10286 C10536 C10685 Sort & Filter Sandy Joch Josh Maria Maria Jenny Clive Elise Cerch Sarah Anna Sue BU Bill Help Fields Selection Advanced Toggle Filter Norm www Ashley Andrew Beth Anne Erin 3 New Save Refresh All X Delete Kelly Kelly Johnston Brown Brown Clomi Fleming Healey Delmer Palmer wame Zimmermann emmer Roberts Gannon wwwww Rydel Marotto Lee Lenhart Gill Table - Records Tell me what you want to do Totals Spelling More Address 465 Grant St. 396 Amherst St. 130 Main St. 291 Ellicott St. 163 Main St. S Domi Perry Dam 7056 Standpipe Rd. Perry 141 Abbott 141 Abbott Rd. 145 Main St 145 Main St. 266 Fimwer 266 Elmwood Ave. Find 87 Main St. 4235 Veteran Dr. 8322 Park Rd. City - State NY Buffalo Buffalo NY Silver Spring: NY Buffalo NY NY Buffalo Buffalo ** Abbott! 141 Abbott Rd. 126 Michigan Ave. 4402 Lakeshore Dr. Castile Casure Geneseo Denese Geneseo Batavia 87 Main St. Geneseo 1353 Lewiston Rd. Basom 196 Oak St. Batavia Buffalo Buffalo Replace Go To. Select- Find Buffala Buffalo MY NY Silver Spring: NY Buffalo NV NY AY NY NY AIX NY NY 10 NY P NY NY NY NY NY NY NY M Calibri (Detail) BIU aby - 11 Zip Phone - 14213 7165554815 14207 7165551400 14550 5855550425 14207 7165558744 14520 5955551003 14530 5855551982 14520 EPEEEE076 14530 5855558765 14 14222 7165550100 14550 FREE001 14550 5855550816 ............. 14222 7165558761 .......... 14222 7165559855 ----- www. 14202 7165557498 www.www. 14427 5855558765 P 14454 5855559763 www 14454 5855556246 14020 7165556578 14454 5855550102 14013 5855556522 14020 7165559765 === , f Text Formatting - Birth Date Gender Click to Add 12/15/1961 M 6/15/1982 M 10/31/1986 M 2/25/1997 F 9/1/1970 M 9/1/1970 M 6/11/1999 E 6/14/1999 F A/15/1960 E 4/15/1968 F 5/4/2001 5/4/2001 F 1/5/1969 F for lancer 2/25/1965 F olabore 8/4/1955 F www. 7/8/1965 M njoyexce 10/28/1982 M www.w 7/4/1985 F 12/1/1982 M 11/16/1986 F 6/1/2012 F 5/4/2013 F