Page 3 of 10PREVNEXT

Create tables for a new Access 2007 database

Building a table in Datasheet view


Datasheet view provides a visual way to create a table.

Callout 1 You start by creating a new, blank database or by adding a new table to an existing database.
Callout 2 The new table opens automatically in Datasheet view. Notice how the new table contains a field called ID. That's your primary key, so you don't need to create one.
Callout 3 To add your fields, double-click the first field header and enter the name for the field. When you finish, press ENTER. Note If your field names contain more than one word, think twice before using spaces to separate each word. Spaces make it harder to write Visual Basic® for Applications code and a type of formula called an expression. It's a common practice to remove spaces entirely, or separate each word with an underscore.
Callout 4 Go to the next blank field and enter a name in that header. Repeat the process until you've entered names for all your fields, but with a couple exceptions: don't add any lookup fields, and don't add foreign key fields. You'll add lookup fields later in this course, and you'll add foreign keys when you create your table relationships in the next course in the series.
Callout 5 When you've finished, go to the Quick Access Toolbar and click Save. In the Save As dialog box, enter a name for the table and click OK.
Page 3 of 10PREVNEXT