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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.