O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Table in Datasheet View

Some people prefer to create their table in Datasheet view. However, Access designed Datasheet view for data entry and viewing, not for table structure changes. I do not recommend creating the table this way, since you do not have access to as many controls as you do with Table Design view.

To create a table in Datasheet view, follow these steps:

  1. Select Insert, Table.

  2. Click Datasheet View and click OK. A blank table opens, as shown in Figure 8.5.

    Figure 8.5. Creating a new table in Datasheet view gives you a quick, generic table.

How Do I Set the Field Names?

When you create a table in Datasheet view, the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required