Page 5 of 11PREVNEXT

Create tables for a new database

Using table designer in Access 2010

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, and you'll get a chance to do that in the practice session.

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

Page 5 of 11PREVNEXT