Microsoft Office Tutorials and References
In Depth Information
An Access user has
been on an eBay
buying binge and needs
to add several doll
records. With a quick
Ctrl+” keystroke, he
can copy the date
from the previous
record into the
DateAcquired field of the
Cut, copy, and paste
Access, like virtually every Windows program, lets you cut and paste bits of
information from one spot to another. This trick is easy using just three shortcut keys:
Ctrl+C to copy, Ctrl+X to cut (similar to copy, but the original content is deleted),
and Ctrl+V to paste. When you’re in Edit mode, you can use these keys to copy
whatever you’ve selected. If you’re not in Edit mode, the copying or cutting
operation grabs all the content in the field.
Gem in the roUGh
Copying an Entire Record in One Step
Usually, you’ll use copy and paste with little bits and pieces
of data. However, Access has a little-known ability that lets
you copy an entire record . To pull it off, follow these steps:
1. Click the margin to the left of the record you want
This selects the record. (If you want to copy more
than one adjacent record, hold down Shift, and
then drag your mouse up or down until they’re all
2. Right-click the selection, and then choose Copy.
This copies the content to the Clipboard.
3. Scroll to the bottom of the table until you see the
new-row marker (the asterisk).
4. Right-click the margin just to the left of the new-row
marker, and then choose Paste.
Presto—an exact duplicate. (Truth be told, one piece of
data doesn’t match exactly. Access updates the ID
column for your pasted record, giving it a new number.)
Unlike other programs, Access doesn’t require that you save your data. It
automatically saves any edits you make to the records in a table. This automatic-saving process
takes place every time you change a record, and it happens almost instantaneously. It