Access XP
Editing and Deleting Table Records
Introduction
By the end of this lesson, learners should be able to:
- Edit a field in a table record in Datasheet View
- Cut, copy, and paste table records
- Use the Undo feature
- Check the spelling of data
- Delete table records
Editing a Table Record in Datasheet View
Information in a record is likely to change over time, when someone moves from one address to another, or when someone else changes his or her phone number. Information can be changed in any field of any table record.
To Edit a Single Word in a Field:
- Move the mouse over the field you want to edit. The mouse pointer changes to an I-beam.
- To add characters to the field information (e.g., a letter needs to be added to a word), click once in the field at the spot where the information needs to be changed. An insertion point | appears.
- To overwrite a word in the field (e.g., "Road" needs to change to "Street"), double-click (or click-and-drag across the word) on the word in the field. Type the new information directly over the highlighted word.
To Edit an Entire Field:
Sometimes, you will need to change the entire contents of a field (e.g., someone has a new address). In Access, you can select an entire field for editing.
- Move the mouse pointer to the left edge of the field you want to edit.
- The mouse pointer changes to a selection tool, a large cross.
- Click to select the field.
- Type the new information.
Warning! When attempting to edit an entire field, be careful not to move the mouse pointer so far to the left that you click on the Record Selector (pointer changes to an arrow pointing right) and select the entire record. In Access, you cannot edit fields when the entire record selected.
Saving Your Work: Unlike the Word, Excel, or PowerPoint applications, you will not be prompted to save the data you entered when you exit the screen or close application. In Access, each record is saved automatically when you move to another record.
Cutting, Copying, and Pasting Table Records
Cut, Copy, and Paste are very useful operations in Microsoft products, including Access XP. These operations allow you to quickly copy and/or cut information in fields for pasting into other fields. These operations save you a lot of time from having to type and retype the same information.
The Cut, Copy, and Paste buttons are located on the Standard toolbar.
The Cut, Copy, and Paste operations also appear as choices in the Edit menu:
The Cut, Copy, and Paste operations can also be performed through shortcut keys:
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
Cutting, Copying, and Pasting Table Records
To Cut Data from a Table:
- Select the data that is to be cut from the table.
- Click the Cut button on the Standard toolbar, or press the Ctrl + X shortcut keys, or choose Edit
Cut from the standard toolbar.
To Copy Data in a Table:
- Select the table data that is to be copied.
- Click the Copy button on the Standard toolbar, or press the Ctrl + C shortcut keys, or choose EditCopy from the standard toolbar.
To Paste Data in a Table:
- Perform either a cut or copy operation on the selected data.
- Position the mouse pointer over the field where the information is to be pasted.
- Click the Paste button on the standard toolbar, or press the Ctrl + V shortcut keys, or choose EditPaste from the standard toolbar.
Using the Undo Feature
There might be occasions when you do something to a table—type the wrong number in a cell, for example—that you didn't mean to do. Fortunately, you can undo an operation in Access XP. The Undo operation recovers the last single action performed.
Certain rules govern use of the Undo feature. First, the record needs to be edited in Datasheet View. Also, Undo becomes unavailable when:
- A different field is edited (Undo of the last field edit cannot be performed).
- A different record is edited (Undo of the last saved record cannot be performed).
- A different window is displayed.
- A filter is applied or removed (filters are discussed in a later lesson.)
To Undo the Last Change to the Current Field, use one of the following methods:
- Click the Undo button on the Standard toolbar.
- Choose EditUndo Current Field/Record from the menu bar.
- Press the Esc key on the keyboard.
Check the Spelling of Data
Spelling data correctly in Microsoft Access is essential. Sloppy data-entry work—the customer name Smithsson is mistakenly typed when the name is actually Smithson—can potentially leave the contact out of future queries or reports. The Spelling Check feature searches for spelling errors in a table, form, or query. In a table, Spelling Check specifically checks the spelling of records, fields, or text within a field.
To Check Spelling in a Table:
- Click on the Spelling button , or choose ToolsSpelling from the menu bar, or press the F7 shortcut key. The Spelling dialog box opens.
- Access provides an alert whenever a word is found that is not in the Dictionary file. The unrecognized word is displayed in the Not in Dictionary text box.
- Correct the word either by performing any of the following actions:
- Type the correct word in the Change To field
- Click the Ignore button to ignore the change and move to the next word
- Highlight the correct word from a list of Suggestions and click the Change button
- Click the Add to add the word to the custom dictionary.
- A notification dialog box is opened when Access completes the spelling check. Click the OK button to close the dialog box.
Deleting Table Records
One or more table records can be deleted from an Access table at any time while in Datasheet View.
To Delete a Table Record:
- Locate the record to be deleted.
- Click the Record Selector to the left of the record's first field to select the entire record.
- Press the Delete key or click the Delete Record button on the toolbar.
- A dialog box is displayed to confirm that the record is to be deleted. Click the Yes button to complete the delete operation.
Deleting Table Records
To Delete Multiple Consecutive Table Records:
- Click the Record Selector to the left of the first record to be deleted, and then drag the cursor up or down across multiple Record Selectors to select consecutive records.
(or hold the Shift key and click the Record Selector field in each consecutive record to be marked for delete.)
- Press the Delete key to mark the records for delete, click the Delete Record button, or choose EditDelete from the menu bar.
- A dialog box is displayed to confirm the record(s) to be deleted. Click the Yes button to complete the delete operation.
Important to Remember:
Deleting records is permanent. It cannot be reversed through an Undo operation. Use caution when the dialog box is displayed to confirm the record(s) to be deleted.
Challenge!
Clean up the following:
- Edit the Deborah Allen record by changing the word "Road" in Street Address to "Highway."
- Navigate to the Bob Binford record, cut the City entry and then type "Holly Springs" as the new City.
- Copy the State entry (Minnesota) in the Mike Allen record and paste it in the State field associated with the Deborah Allen record
- Run Spellcheck and verify the accuracy of all words in the table.
- Delete the Deborah Allen record