O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Existing Fields to a Table

Rather than force you to create a new table from scratch when you start a new database, Access lets you use the Field Templates task pane to choose commonly used fields from a number of preconstructed tables. The tables are the same tables found when you click the Table Templates button on the Create tab, but they contain a wide variety of fields that enable you to flesh out your tables with a minimum of effort. You can also copy fields from existing tables into your new table. When you click the Add Existing Fields button, Access displays the Field List task pane, which contains the structure of your existing tables and lets you copy those fields into your tables.

Add Fields from the Field Templates Task Pane ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required