How to Cut, Copy, and Paste Data in Access
In Microsoft Access, you can cut, copy, and paste any of the following items: text, records, database objects (tables, queries, forms, and reports), or controls (such as text boxes and labels on forms and reports).
You can copy text by pressing Ctrl + C.
You can paste text by pressing Ctrl + V.
To copy and paste a record, select the record’s row selector, copy the record, select an empty row for the new record, and paste the copied record.
Cutting and pasting information is almost the same as copying and pasting text.
You can also cut text by pressing Ctrl + X.