Repeating data from the record above


show more Repeating data from the record above provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Repeating data from the record above

When you're entering data, you may find times when it will be helpful to repeat information from previous records. Here are some useful techniques so you don't have to type the same information over and over again. I am going to open up my Products table. I am going to go to the bottom to start a new record. I am going to add a new size, a 4 ounce bottle to my product line. To duplicate my ID, I will hold down my Ctrl key and type a quotation mark, the key just to the left of the Enter key. It will copy the data directly above it. Press F2 and the insertion point will move to the end of the data. I will backspace 3 times to erase the numbers and enter 004, my new bottle size.

I will press Tab and then Ctrl+" mark again and as before my data will be copied from directly above. I can then continue tabbing across to enter the rest of my record. If a lot of the data is the same, I can even copy entire records and then just change some of the fields. Let's say I have a new oil and...

Repeating data from the record above
Video duration: 1m 39s 3h 43m Intermediate

Viewers:

Repeating data from the record above provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...