Creating Tables   «Prev  Next»

Lesson 5 Using Cut, Copy and Paste to enter data more quickly
Objective Enter, edit and copy data in Access.

Using Cut, Copy and Paste to enter Data more quickly

Depending on the data you are entering, you may find that there are times when you just want to copy a piece of data rather than retyping something that you have already typed.
If you know how to copy and paste in another Windows application, you probably already know how to do it in Access. Here are the specifics:
  1. First, select the data you want to copy.
  2. Press Ctrl-C, click the Copy button, or choose Edit>>Copy from the menu.
  3. Move the cursor to where you want to copy the data.
  4. Press Ctrl-V, click the Paste button, or choose Edit>>Paste from the menu. The data will be copied to the new location.
There are three easy ways to complete the cut, copy, and paste actions: you can use the keyboard, the toolbar, or the menu. View the table below to see a quick-reference table.
Action What it does Keyboard Toolbar button Menu choice
Cut Deletes the selected text and stores it on the clipboard Ctrl-X Access Cut Edit>>Cut
Copy Copies the selected text to the clipboard Ctrl-C copy to clipboard Edit>>Copy
Paste Pastes the contents of the clipboard to the cursor’s location Ctrl-V Pastes the contents of the clipboard to the cursor Edit>>Paste

Access 2000 had a new feature that you may not be familiar with, where it allows you to store multiple “clips” on the clipboard and paste them where you want. This flexibility can be very useful, as you will see.
If you are entering repeating data use Ctrl-’ – it repeats the data in the record above for the current field.

Cutting Pasting - Database Elements
In the following Slideshow I will show you an easy way to complete a table using the multiple clip feature for cutting and pasting.

1) Copy Data 1 2) Copy Data 2 3) Copy Data 3 4) Copy Data 4 5) Copy Data 5 6) Copy Data 6 7) Copy Data 7 8) Copy Data 8
Copy Paste Data

Cut Copy Paste - Exercise

Enter data into your Clients table in this exercise.
Cut Copy Paste - Exercise