Access+editing+data+on+a+form

Home / software / microsoft access / Tutorials

> > > Notice that the Phone # of that record is incomplete > In the Navigation Pane, double-click Customers: Table to open it > > > Click Find Next
 * Practical Learning: Editing Data ||
 * 1) From the resources that accompany these lessons, open the Ceil Inn2 database
 * 2) In the Navigation Pane, double-click Customers: Table to open it
 * 3) In record number 2, click the empty box under Emergency Name
 * 4) Type **Albert Lomey** and press Enter
 * 5) Close the table
 * 6) In the Navigation Pane, under Customers: Table, double-click Customer to open the form
 * 7) Click the Next Record button once [[image:http://www.functionx.com/access2007/buttons/nextrec1.gif width="16" height="16"]] to navigate to the second record
 * 8) Click the Emergency Name label and type 301-412-5055
 * 9) Close the form
 * 10) In the Navigation Pane, double-click Customers: Table to open it
 * 11) In the Find section of the Ribbon, click the Find button [[image:http://www.functionx.com/access2007/buttons/find1.gif width="42" height="66" caption="Find"]]
 * 12) In the Find What combo box, type **Carney**
 * 13) In the Look In combo box, select Customers
 * 14) In the Match combo box, select Any Part of Field
 * 1) In the Match combo box, select Any Part of Field
 * 1) Click Find Next
 * 2) Click Find Next again. Notice that a second result is found
 * 3) In the second result, while the Find and Replace dialog box is still opened, on the table, click the found Carney and press Tab three times to get to its Emergency Phone
 * 4) Press F2 to position the caret in the cell and edit it to display **990-326-5144**
 * 5) In the Find and Replace dialog box, replace Carney with **Beckins**
 * 6) Click Find Next.
 * 1) Click the right side of the incomplete telephone number and type **1440** to make it 410-944-1440
 * 2) Click the Find and Replace dialog box
 * 3) The Ceil Inn5 database should still be opened.
 * 1) In the Find section of the Ribbon, click the Replace button [[image:http://www.functionx.com/access2007/buttons/replace1.gif width="66" height="22" caption="Replace"]]
 * 2) In the Find What combo box, type **ratner**
 * 3) In the Replace With combo box, type **Rattner**
 * 4) In the Look In combo box, select Customers
 * 5) In the Match combo box, select Any Part of Field
 * 1) Click Find Next
 * 2) Once the value is found, click Replace
 * 3) Close the Find and Replace dialog box and close the table
 * 4) In the Navigation Pane, under Customers: Table, double-click the Customers form
 * 5) Press Ctrl + H to display the Replace dialog box
 * 6) In the Find What combo box, replace the string with **Annie** and press Tab
 * 7) In the Replace With combo box, type **Annette**
 * 8) Make sure the Look In combo box displays Customers and make sure the Match combo box is set to Any Part of Field.
 * 1) Once a match is found, click Replace All
 * 2) Click the right side of the incomplete telephone number and type 1440 to make it 410-944-1440
 * 3) Close the Find and Replace dialog box and close the form