Page 6 of 10PREVNEXT

Create tables for a new Access 2007 database

Starting and using the table designer


Design view allows you to build a table from scratch and set or change every available property for each field. You can also open existing tables in Design view and add, remove, or change fields.

Callout 1 On the Create tab, in the Tables group, click Table Design.
Callout 2 In the Field Name column of the designer, enter the names of your table fields. As a rule, the first field you create should be your primary key field. And remember that you don't need to add any foreign key fields now. You can do that when you create your relationships.
Callout 3 In the Data Type column, use the list next to a field name to choose a data type for that field.
Callout 4 Optionally, use the Field Properties pane to set properties for individual fields. For example, you can use the pane to change the values in a lookup field. You'll get a chance to do this in the practice session.

As always, save your changes and give your new table a name that describes the data it contains.

Page 6 of 10PREVNEXT