MS-Access / Getting Started

Creating a Table in Design View

You could continue to use Application Parts and Data Type Parts to build some of the other tables in the Contact Tracking database to mimic those in Conrad Systems Contacts. However, you'll find it very useful to learn the mechanics of building a table from scratch, so now is a good time to explore Design view and learn how to build tables without using Application Parts or Data Type Parts. Application Parts offer only a few choices for sample tables, and there is no way to pick and choose which fields to include or exclude. By working in Design view, you'll see many additional features that you can use to customize the way your tables (and any queries, forms, or reports built on these tables) work when creating a table from scratch.

To begin creating a new table in Design view, click the Create tab on the ribbon and then click the Table Design button in the Tables group. Access 2010 displays a blank Table window in Design view.

In Design view, the upper part of the Table window displays columns in which you can enter the field names, the data type for each field, and a description of each field. After you select a data type for a field, Access 2010 allows you to set field properties in the lower-left section of the Table window. In the lower-right section of the Table window is a box in which Access displays information about fields or properties. The contents of this box change as you move from one location to another within the Table window.

[Previous] [Contents] [Next]