Copying fields

As you create table definitions, you might find that several fields in your table are similar. Rather than enter each of the field definitions separately, you can enter one field definition, copy it, and then paste it as many times as necessary.

To finish defining our Contacts table, we need five additional fields—HomeAddress, HomeCity, HomeStateOrProvince, HomePostalCode, and HomeCountry. You could insert a new row and type all the properties as you just did in the previous section, but why not copy a field that is similar and make minor changes to it?

For this part of the exercise, select the row for the WorkAddress field definition by clicking the row selector at the left of the row. Click the Copy command in the Clipboard group ...

Get Microsoft Access 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.